Online Documentation for SQL Manager for InterBase/Firebird

Managing database-specific privileges


This window allows you to define privileges on database objects and grant privileges to a user, role, view, trigger, or procedure.

 

To edit the privileges of a user/role/view/trigger/procedure on an object of a database, select the database using the Database pane of the Navigation bar, then select a user, a role, a view, a trigger, or a procedure from the Privileges for list available within the Navigation bar. Then select the type of objects to be displayed in the main working window using the drop-down list at the top.

 

The Object Name column contains the list of objects of the selected type; each subsequent column corresponds to the permission which can be granted on the selected object:

SEL, INS, UPD, DEL, References (for tables, views);

Execute (for procedures);

Usage (for exceptions and generators).

 

Grant Manager - Managing database-specific privileges

 

The list of objects can be configured in several ways: you can specify that only granted objects are displayed in the grid, or define an object name to filter the objects by that name.

 

Right-click a cell to grant a specific permission on a certain object. To grant a permission on an object, you should find the object in the Object Name list and the column with the corresponding permission. The context menu of a cell contains possible permissions that can be granted:

iconGrantManager_Grant Grant

iconGrantManager_Revoke Revoke (removes a previously granted permission)

iconGrantManager_GrantWithGrantOption Grant with GRANT Option

iconGrantManager_GrantAll Grant All

iconGrantManager_RevokeAll Revoke All

iconGrantManager_GrantAllWithGrantOption Grant All with GRANT Option

iconGrantManager_GrantOnAll Grant on All

iconGrantManager_RevokeOnAll Revoke on All

iconGrantManager_GrantWithGrantOptionOnAll Grant on All with GRANT Option

iconGrantManager_GrantAll Grant All on All

iconGrantManager_RevokeAll Revoke All on All