Database Administration (MOSC)

MOSC Banner

User able to create tables without quota

edited Jul 18, 2014 5:00AM in Database Administration (MOSC) 4 commentsAnswered

How come PATEST user is able to create table in his own tablespace , even in another tablespace when no quota is defined for it?

DBA_USER  prod_padw >create user patest identified by Temp1234 default tablespace users temporary tablespace temp ;

User created.

DBA_USER  prod_padw >grant Create session, Create table, Create procedure, Create sequence, Create synonym to patest;

Grant succeeded.

DBA_USER  prod_padw >
DBA_USER  prod_padw >conn patest/Temp1234@prod_padw
Connected.


PATEST  prod_padw >create table test (name varchar2(100));

Table created.

PATEST  prod_padw >create table test1 (name varchar2(100)) tablespace PA_DATA01;

Table created.


PATEST  prod_padw >select tablespace_name, table_name from user_tables;

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center