Skip to Main Content
Forums

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Unlimited Tablespace Privilege

388975Jun 8 2003 — edited Jun 11 2003
I have one user in the database say'user1'. Let this user has only 'create session' privilge.

I have two sessions open. In one session I am connect as:

"sys/oracle as sysdba" and in other session, I am connect as : "user1/user1".

Now from "sys" session I am granting dba privilege to 'user1'. "grant dba to user1".

When I go to "user1" session and fire a command with out reconnecting :
'select * from session_privs', I see the only two privileges

1 . Create session
2. Unlimited Tablespace.

Here I understand that :

1. I need to connect again as user1/user in order to reflect the dba privilges.

2. But even if I do no connect again, why am I getting "Unlimited Tablespace " privilge.

My question is : Is there something special about this privilege or is this a bug?

Comments

Processing
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Jul 9 2003
Added on Jun 8 2003
#general-database-discussions
5 comments
430 views