Connect using database user credentials

This method needs a database user with db_datareader role (for sampling data) and view definition privilege (for access policy).

Steps:

1. Create SQL login in master database. Query

   CREATE LOGIN [testLogin] WITH PASSWORD = '<strong_password_goes_here>';

2. Switch to the database and Add Database user for above login. Query CREATE USER [testUser] FROM LOGIN [testLogin];

3. Add user to default database role (db_datareader) and grant view definition privilege. Query

   ALTER ROLE db_datareader ADD MEMBER [testUser];

   GRANT VIEW DEFINITION TO [testUser];

Required Parameters:

• Server name (example: testdb.database.windows.net)

• Database name

• Login name

• Password