Access control determines the set of operations that can be performed on a table or view in a GDBase database. The following options are available:
the privilege read (r) permits the user to read a table or view, allowing him/her to execute the following commands:
the privilege write (w) permits the user to change the data in a table, allowing him/her to execute the following commands:
The access privileges of a particular user for a table or view are determined according to the following rules:
If the user is an administrators he/she is granted both read and write prvileges.
If the user is the owner of the table or view he/she is granted both read and write prvileges.
If the user has special privileges for the table or view he/she is granted the read and/or write privileges, according to his/her set of special privileges.
All other users are granted access privileges according to the default properties of the table or view.
Each table (or view) in a database has a set of default properties which determine the access rights to this table.
Read ('r') allows other users to read data from the table.
Write ('w') allows other users to write data to the table.
These properties are determined when the table is created on the basis of the properties of the user who creates the table. (see the User Properties section).
The default table properties determine access privileges for the table for all users except:
the owner of the table , who always has read and write privileges,
administrators , who always have read and write privileges,
users with special privileges for this table (in this case the special privileges override the default ones).
Default table properties can be changed with the GRANT 'properties' ON [cat.]tab' and REVOKE 'properties' ON [cat.]tab commands (see the Granting privileges and Revoking privileges sections).
To check the default table proprties use the SHOW DEFAULT TABLE GRANTS ON [cat.]tab command (see the Displaying privileges section).