can i create a user but then cannot alter it?

In Azure, Login is not a user, it’s used to login the Azure SQL database, you need create the user for login: CREATE USER BOB1 FOR LOGIN bob1, then run ALTER USER bob1 WITH DEFAULT_SCHEMA = dbo;. But it’s not necessary, the default schema is dbo, we could not specify it.

Create login to log in the Server/database, then mapping the user to login.

After that you need alter the user enough permission/role to access the database, for example:

ALTER ROLE db_owner ADD MEMBER 'bob1'

Please ref here: Authorize database access to SQL Database, SQL Managed Instance, and Azure Synapse Analytics

CLICK HERE to find out more related problems solutions.

Leave a Comment

Your email address will not be published.

Scroll to Top