ILT – Easy Method To Manage or Map SQL Server User Access To SQL Server Databases

14-08-2012

How to easily map a SQL Server user to databases?

  1. Select the login you want to grant or deny access from the “Logins” sub-folder in the “Security” Folder in the SQL Server
  2. Right click on the user and select “Properties”
  3. Select “User Mapping” from the “Select a page” section
  4. You will see the list of databas in the “Users mapped to this login:” section
  5. Tick the check box in the “Map” field/column for databases you want to grant access for the selected user and ensure you un-tick the check boxes you don’t want your user to access
  6. Select the database role you want to grant for this user from the “Database role membership for:” section. This will allow you to fine-tune access rights.

You can easily enable/disable users from accessing databases in seconds.

Easy method to allow or block SQL server databases for SQL server users.

You can see a screenshot below this post:

Menol
ILT

Screenshot: Easy Method To Manage or Map SQL Server User Access To SQL Server Databases
Easy Method To Manage or Map SQL Server User Access To SQL Server Databases

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: