User Properties window: Permissions tab

This tab has the following components:

Permissions list Shows all tables the user has permissions on, as well as the user who owns each table. You can click the fields for each table 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 what type of object appears in the Permissions list:

Tables All tables the user has permissions on.
Views All views the user has permissions on.
Procedures & functions All procedures and functions the user has permissions on. You can only grant Execute permissions for procedures and functions.
Dbspaces All dbspaces the user has permissions on. Only CREATE permission is supported. See Permissions on dbspaces.

User Properties window: Permissions tab

See also