Transferring access permissions in a database (Model Explorer)
 |
This tasks transfers access permissions for all models and packages in a selected database. To transfer access permissions, you must be a Database Administrator.
|
To transfer access permissions in a database:
1. Start Model Explorer.
For more information, see Starting Model Explorer.
2. Right-click on a database, point to Principals then click Transfer Permissions.... The Transfer Permissions dialog appears.
3. In the from box, enter a user or a group name to transfer permissions from.
4. In the to box, enter a user or a group name to transfer permissions to, then click OK.
User and group names should be entered in the following format: <domain>\<user-or-group>
5. Click OK to confirm.