Limiting Roles to Specific Companies for a Login

Initially roles are database specific and apply to all the companies in that database. But you can limit roles to specific companies.

The following procedure limits a role to a specific company for a database login, but the same procedure can also be used for Windows logins.

To Limit a Role to a Specific Company:

  1. Click Tools, Security, Database Logins and the Database Logins window appears.

  2. Select the database login in question and click Roles and the Database Logins window for this role appears listing all the roles that have been assigned to this login.

  3. Select the role that you want to make company specific.

  4. In the Company field, click the AssistButton and the Companies window appears.

  5. Select the company to which this role should apply and click OK.

  6. Close the window and agree to rename the record.

You must create a separate line for each specific company for which you want this role to apply. If you specify that the permissions a user has only apply to a particular company in the database, the user in question will only be able to see that company.

Related Topics

Security

Creating Database Logins

Giving Database Logins a Role

Giving Roles to Database Logins

Creating Roles

Modifying Permissions for Roles

Assigning Permissions to Multiple Objects



© 2009 Microsoft Corporation. All rights reserved.