Getting Started
Search
K

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. 1.
    Create SQL login in master database. Query
    CREATE LOGIN [testLogin] WITH PASSWORD = '<strong_password_goes_here>';
  2. 2.
    Switch to the database and Add Database user for above login. Query CREATE USER [testUser] FROM LOGIN [testLogin];
  3. 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