Read-only and full access permissions
The actions that users can perform on a
database with
coarse-grained authorization are determined by the type of access that users
have to the database objects.
permissionsread-only access
permissionsfull access
The following table lists the actions that users can perform based
on the type of access that a user is granted on a database.
Actions that are authorized by type of access
This table shows whether various actions are permitted with read-only and with full access to a database.
Action
Read-only access
Full access
Executing SELECT statements
Yes
Yes
Reading database properties
Yes
Yes
Loading database classes from jar files
Yes
Yes
Executing INSERT, UPDATE, or DELETE statements
No
Yes
Executing DDL statements
No
Yes
Adding or replacing jar files
No
Yes
Setting database properties
No
Yes