Field or Control |
Description |
Database Name |
Specify the database or user to grant or revoke privileges. Note: The UDT Usage check box is only available when the SYSUDTLIB database is selected. |
Object Type |
Specify the type of object to grant privileges. When one of the Types is selected, the check boxes for the privileges that are available for that type of object are activated. If any type except Database is chosen, the Object list displays all the objects of the selected type contained in the selected database. |
Object |
Displays all of the database object names of the type specified in the Object Type box for the user or database selected in the Database field. Select the name of the object to grant or revoke general access privileges. |
To/From User |
Displays all of the users and databases of the data source that are being worked with. Select the name of the user or database to grant general access privileges. To select multiple users, press and hold |
Role |
Displays all of the roles that exist on the data source that are being worked with. Select the name of the role to grant general access privileges. To select multiple roles, press and hold |
And All Children |
Applies to the user or database selected in the To User list. Select to extend general access privileges to all the children of the selected user or database. This extension applies to all currently-owned users and databases, and to any that might become owned in the future. Note: If multiple users are selected, the And All Children option is added only to the first user in the list. |
Public |
Select to extend the general access or column privileges to all users and databases on the currently selected database. This applies to all currently defined users and databases, and to any that might be defined in the future. |
Normal |
Select to specify the general access privileges to grant or revoke for the user specified in the To User or From User box. |
Create |
Select to specify the create privileges to grant or revoke for the user specified in the To User or From User box. |
Drop |
Select to specify the drop privileges to grant or revoke for the user specified in the To User or From User box. |
All |
Selects all available rights for those whose check boxes are active in the Normal, Create, and Drop areas of the dialog box. |
Dictionary |
Selects all available dictionary-related rights. |
Access |
Selects all available data access rights. |
All But |
Select to either grant or revoke all of the privileges whose check boxes are active except those that have been selected. |
Grant |
Select to grant the selected privileges to the selected To User. It also gives this user the ability to Grant the selected privileges to others. Select to revoke, from the selected To User, the right to Grant the selected privileges. To revoke the privileges themselves, issue a second Revoke command without this check box selected. |