To edit user permissions on an object
Right-click an object in the Object Explorer and select Edit Permissions.
Complete the fields as necessary. Review the following for additional information:
List all objects/ |
Select whether you want to view permissions for all objects or only those objects hat currently have permissions assigned to this database. The default is List all objects. 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 type listed. Note: You can revoke all permissions for an object by clicking Revoke. |
Repeat step 2 for each user or role you want to modify.
You can display details about a database by selecting it in the Object Explorer. The following table describes the details associated with each database:
Use this tab... |
To display... |
---|---|
Properties |
Characteristics of the database such as the owner, size, available space, and number of users. Space Usage chart below represents space allocation. |
Filegroups |
Any filegroups associated with the database. |
Files |
Information about the data and log files associated with the database. |
Extended Properties |
Extended properties you define to store additional metadata for this object. |
Script |
SQL statements for the selected object. |
Tip:
Right-click the object to see additional actions and tasks available for it.
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Conditions d’utilisation Confidentialité Cookie Preference Center