Database Reference
In-Depth Information
Figure 23.7
A Table That
Really Exists Is
Invisible to an
Unauthorized
User.
A different message appears when you do not have the system privi-
lege needed to perform a task. We could create a simple table, such as the
following:
CREATE TABLE SEASHELLS (SHELLNAME VARCHAR2(20));
Figure 23.8 shows the result. ARIEL has not been granted the CREATE
TABLE system privilege, and therefore Oracle Database 10
g
issues an error
message stating “insufficient privileges.”
Figure 23.8
Cannot Create a
New Table without
the CREATE
TABLE System
Privilege.
