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!

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

Comments

Alex
Hi

e-Spider is not a supported product in fact any references to e-Spaider should have been removed a wile back.

Regards

Alex
1 - 1
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Apr 22 2011
Added on Mar 25 2011
#general-database-discussions
8 comments
15,910 views