Database Reference
In-Depth Information
Figure 23.5
Granting System
and Object
Privileges Uses
Similar Syntax.
CONNECT SYSTEM/password@OLTP;
Start by creating two new users on which to experiment by running the
following commands. The PRINCE user will be creating tables, so he needs
additional parameters that allow him to use a tablespace for the tables.
CREATE USER ARIEL IDENTIFIED BY MERMAID;
CREATE USER PRINCE IDENTIFIED BY CHARMING
DEFAULT TABLESPACE USERS QUOTA 2M ON USERS;
Note:
The DEFAULT TABLESPACE and QUOTA options are DBA
things but necessary to allow creation of stuff like tables.
Grant the system privilege that allows these two users to connect to the
database.
GRANT CREATE SESSION TO ARIEL, PRINCE;
