MSSQL – Azure

Code | MSSQL | MSSQL - Audit | MSSQL - Azure | SQL

MSSQL – List Users With Permissions
ByDavid Kittell June 21, 2017June 22, 2017

Sometimes you really just need to know how many users you have on your database, the below script will give a quick report for your database. Note: This script is designed to run on a selected database, you will have to select the database first and then run the script.

Read More MSSQL – List Users With Permissions
Azure | Code | MSSQL | MSSQL - Azure | SQL

Microsoft Azure SQL – Create SQL User
ByDavid Kittell October 13, 2016

In this example I create a Read-Only user but this will work with any access as long as you change the db_datareader access role to what you need In SQL Management Studio open a “New Query” with [master] database Again in SQL Management Studio open a “New Query” with the specific database you want to…

Read More Microsoft Azure SQL – Create SQL User