Database Administration (MOSC)

MOSC Banner

Create table privilege in 11,2.0.2

edited Jun 19, 2012 7:36PM in Database Administration (MOSC) 9 commentsAnswered
Hi,
We use Oracle Database 11.2.0.2. We create new schema, assign default tablespace, and grant create table privilege to this schema.
The issue is this schema is able to create new table using another tablespace other than its default tablespace.

There are only create session and create table system privileges that granted to this new schema.

What is wrong? Please advise...

Thanks,
KLM

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