Privileges on database objects can be granted on the Object Privileges tab of the Security Manager. To open the Security Manager, select Security Manager on the Database menu.
To give user some privileges on a database object, perform the following actions.
Select a user account in the user account list in the left part of Security Manager and switch to the Object Privileges tab.
The grid below the Object Privileges tab of Security Manager contains the current privileges of the user (account). You can revoke a selected privilege by double-clicking it, clicking Revoke Selected Privilege on their shortcut menu, by pressing CTRL+DELETE keys, or by clicking the button next to the list.
To revoke all assigned privileges, select Revoke All Privileges on their shortcut menu or click the button near the list.
Available privileges for different database objects are listed at the table below:
Database objects | Privileges |
---|---|
Databases | Select, Insert, Update, Delete, Alter, Alter Routine, Create, Create Routine, Create Temporary Tables, Create View, Drop, Event, Execute, Grant Option, Index, Lock Tables, References, Show View, Trigger |
Tables | Select, Insert, Update, Delete, Create, Drop, Grant Option, References, Index, Alter, Create View, Show View, Trigger |
Columns | Select, Insert, Update, References |
Stored procedures and functions | Alter Routine, Execute, Grant Option |