|
The Permissions tab of the Consolidated User property sheet has the following components:
Permissions list Shows all tables the consolidated user has permissions on, as well as the user who owns each table. You can click the fields beside each user to grant or revoke permissions; double-clicking (so that a checkmark and two + signs appear) gives the user grant options for the permission.
Show Select the type of object appears in the Permissions list:
Tables Displays all tables the consolidated user has permissions on.
Views Displays all views the consolidated user has permissions on.
Procedures & functions Displays all procedures and functions the consolidated user has permissions on. You can only grant Execute permissions for procedures and functions.