The GRANT statement, which is a definition SQL statement, is used to grant the following privileges to users who will creates tables:
GRANT CONNECT TO USER002 IDENTIFIED BY HIRDB002
GRANT SCHEMA TO USER002
GRANT RDAREA RDAREA01 TO USER002
A schema can be defined for a user to whom the schema definition privilege is to be granted. The schema definition privilege is then granted to the user that defined the schema.
When defining a private RDAREA,* the HiRDB administrator can grant the RDAREA usage privilege to that private RDAREA.
* The following utilities and control statements are used:
After revoking RDAREA usage privileges to a private RDAREA, use the GRANT statement, which is a definition SQL statement, to change the RDAREA. For details about revoking RDAREA usage privileges, see 2.3(4) Revoking RDAREA usage privileges.
GRANT RDAREA RDAREA02 TO PUBLIC