TIP: The Grant task provides a quick way to grant permissions. See Using the Grant task. For more options, add a path, and click Switch to Security Explorer Classic (Advanced). The path carries to the Grant SSRS Permissions dialog boxes, but the permissions do not.
|
4 |
Open the SQL Server Security module. |
5 |
Open the Browse tab. |
7 |
Select Security | Grant. |
8 |
Click Advanced User Selection to select a group/user. |
9 |
From the Role list, select a role to grant. To select more than one role, click Advanced Permission Selection. |
10 |
NOTE: Only users and groups in the List of users and groups to grant list are affected by the grant action. You can sort each column by clicking the column heading. To remove a selected user or group from the list, click Remove. |
11 |
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 |
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center