Azure: Login User Creation and Permission

Connect to your Azure SQL Database server with SSMS as an admin in master. 

1. Connect to azure

2. Create a SQL authentication login called ‘test’ with a password of ‘Abcd123$’.

3. Create a user mapped to the login called ‘test’ in a database.

4. Add user to the db_datareader role.

5. Connect to your Azure SQL Database server with SSMS. Add a SQL authentication login called  ‘test’ with a password of ‘Abcd123$'

Select database and encrypt connection:

Verify user permission by selecting tables.