DATABASE OBJECT LEVEL PRIVILEGES

grant create session , create table to u1

Statement processed.

0.01 seconds
u1>create table e1(n number);
Table created.
u1>insert into e1 values (1);
1 row created.
u1>commit;
Commit complete.

u1>grant select , insert , update , delete on e1 to u2;

Grant succeeded.
u1>conn u2/u2
Connected.
u1>sho user;
USER is "U2"

u1>select * from u1.e1;

         N
----------
         1

u1>insert into u1.e1 values (2);

1 row created.


u1>select * from u1.e1;

         N
----------
         1
         2
u1>conn u1/u1
Connected.
u1>revoke select , insert , update , delete on e1 from u2;

Revoke succeeded.