Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All
Expand Minimize

Object Properties (Permissions Tab)

SQL Server 2000

Use this tab to view or specify the following options.



Specify the name of the object.

List all users/user-defined database roles/public

List all users and database roles for the selected database. Click the appropriate box to modify object permissions.

List only users/user-defined database roles/public with permissions on this object

List only users or database roles that already have permissions on the object. Click the appropriate box to modify database user permissions.

User/Database roles/public

View the user ID or database role.


Grant, revoke, or deny SELECT permissions on this object.


Grant, revoke, or deny INSERT permissions on this object.


Grant, revoke, or deny UPDATE permissions on this object.


Grant, revoke, or deny DELETE permissions on this object.


Grant, revoke, or deny EXECUTE permissions on this object.


Grant, revoke, or deny declarative referential integrity permissions on this object.


Display the Column Permissions dialog box, where you can manage permissions for each column.

See Also

Managing Permissions

© 2015 Microsoft