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!

giving grant for creating temporary table only

793965Mar 25 2011 — edited Mar 25 2011

hi...
i want to give grant for creating only temporary tables to a schema.
no other grants should not be there strictly...

I have created the following user widout any grants...plss suggest me how can i give the grants for creating only temporary tables..

create user user_name
identified by password
default tablespace table_space
temporary tablespace TEMP
profile DEFAULT
quota unlimited on table_space;

grant select on V_$SESSION to user_name;

thanks...

Edited by: user12780416 on Mar 25, 2011 8:32 AM

This post has been answered by JustinCave on Mar 25 2011

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 22 2011

Added on Mar 25 2011

#general-database-discussions

8 comments

16,094 views