TIP: The Clone task provides a quick way to clone permissions. For more options, add a path, and click Switch to Security Explorer Classic (Advanced). The path carries to the Clone SQL 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. The selected pair displays in the List of users and groups to clone list. |
Select to add the destination account to the groups of which the source user is a member. |
9 |
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. |
1 |
Open the SQL Server Security module. |
2 |
Open the Browse tab. |
4 |
Select Search | Search in a New Window (Empty). |
5 |
Click Start Search. |
Each module has a set of search criteria grouped into tabs. As you set criteria, you can update the results by clicking Start Search at any time.
By default, a search returns permissions based on the specified search criteria. | |
Search for passwords which are blank or fail a strong password test |
Select to search for SQL Server® logins with blank passwords or those where the password is the same as the user name. |
You can search for the names of the Grantee and/or Grantor, or Permission types.
By default, all permissions are included in the search. To remove a permission from the list, clear the corresponding check box. To remove all permissions, click None. To select all permissions, click All.
© ALL RIGHTS RESERVED. 이용 약관 개인정보 보호정책 Cookie Preference Center