Question

If an existing login can access the master database of an Azure SQL Server, which type of object needs to be created before the login can access another database on the same server?

Schema

User

Certificate

Firewall

Answer 1

Answer:

Firewall

Explanation:

Answer 2

If an existing login can access the master database of an Azure SQL Server, User needs to be created before the login can access another database on the same server.

• Users are created per database and are associated with logins. You must be connected to the database in where you want to create the user. In most cases, this is not the master database.
• Here is some sample Transact-SQL that creates a user:

                    CREATE USER readonlyuser FROM LOGIN readonlylogin;