Security
Database Security
Create and Alter Users
Note: This topic focuses on information that may be unfamiliar to you. It does not include all step and field descriptions.
To create or alter a user
- Select Users node under the Security node in the Object Explorer.
- Select one of the following:
- Click
to create a user.
- Select a user and click
to create a user like the selected one.
- Select a user and click
to alter it.
- Click
-
Complete the fields as necessary. Review the following for additional information:
Security type Specify the way of securing the user. It can be associated with login, mapped with certificate or symmetric or asymmetric key, etc. Schemas owned by this user
Select the checkbox beside any schemas you want this user to own.
Database role membership
Select the checkbox beside any database role you want to assign to this user.
Edit User and Role Permissions
To edit a user or role permission
-
In the Database Security Management window, select the Permissions page.
-
Complete the fields as necessary. Review the following for additional information:
List all objects/
List objects with active permissions
Select whether you want to view permissions for all objects or only those objects hat currently have permissions assigned to this database.
Note: You cannot modify permissions for the dbo user.
Objects
Select the object for which you want to set permissions.
Permissions
Select whether you want to allow or deny permissions for each object type.
Note: You can revoke all permissions for an object by clicking Revoke.
- Set column permissions if needed. See Set Column Permissions for more information
-
Repeat Steps 2 and 3 for each object on which you want to modify permissions.