QUOTAS ON USERDATA

alter user scott quota 200k on userdata;

select * from user_ts_quotas;


TABLESPACE_NAME                     BYTES  MAX_BYTES     BLOCKS MAX_BLOCKS DRO
------------------------------ ---------- ---------- ---------- ---------- ---
USERDATA                                0     204800          0         25 NO


alter user scott quota unlimited  on userdata;
TABLESPACE_NAME                     BYTES  MAX_BYTES     BLOCKS MAX_BLOCKS DRO
------------------------------ ---------- ---------- ---------- ---------- ---
USERDATA                                0         -1          0         -1 NO

create user u1 identified by u1 default tablespace  userdata quota 300k on userdata;

User created.

0.22 seconds

grant create session , create table to u1 with admin option;

Statement processed.

0.08 seconds

SQL> conn u1/u1
Connected.
SQL> set sqlp u1
u1set sqlp u1>
u1>




u1>create user u2 identified by u2 default tablespace userdata;
create user u2 identified by u2 default tablespace userdata
                             *
ERROR at line 1:
ORA-01031: insufficient privileges

create user u2 identified by u2 default tablespace userdata;

u1>grant create session , create table to u2 ;

Grant succeeded.


revoke create session , create table from  u1