Security Manager allows granting and revoking system and object privileges easily. This topic describes how to work with system privileges and privileges on database objects.
Privileges on database objects can be granted on the Object tab of the Security Manager.
To give a user or role some privileges on a database object, perform the following actions.
The grid at the bottom of the Security Manager Object tab contains the current privileges of the user (account) or role.
You can revoke selected privilege by:
To revoke all assigned privileges, select Revoke All Privileges from 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 |