TIP: The Revoke basic task provides a quick way to revoke permissions. See Using the Revoke tasks. For more options, add a path, and click Switch to Security Explorer Classic (Advanced). The path carries to the Revoke SQL Permissions dialog box, but the permissions do not.
|
1 |
Open the SQL Server Security module. |
2 |
Open the Browse tab. |
4 |
Select Security | Revoke Permissions. |
5 |
Click Advanced User Selection to select a group/user. |
6 |
Select a role to revoke. To select more than one role, click Advanced Permission Selection. |
8 |
TIP: The Clone task provides a quick way to clone permissions. See Using the Clone task. For more options, add a path, and click Switch to Security Explorer Classic (Advanced). The path carries to the Clone SSRS Permissions dialog box, but the permissions do not.
|
1 |
Open the SQL Server Security module. |
2 |
Open the Browse tab. |
4 |
Select Security | Clone Group or User. |
5 |
In the Source Group or User area, click User Selection to select the domain or object from which to pull the permissions. |
6 |
In the Destination Group or User area, click User Selection to select the domain or object to receive the cloned permissions. |
7 |
Click Add. |
8 |
1 |
Open the SQL Server Security module. |
2 |
Open the Browse tab. |
4 |
Select Search | Search in a New Window (Empty). |
6 |
Click Start Search. |
1 |
Open the SQL Server Security module. |
2 |
Open the Browse tab. |
4 |
Select Security | Modify Permissions. |
NOTE: If you want to change to another Principal name, click Change. The Select objects box lists the available objects. Select another name, and click OK. |
6 |
Click OK. |
© ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center