OraFAQ Forum: Server Administration » temp tables

Home » RDBMS Server » Server Administration » temp tables - readonly user (10.2.0.4.0, RH Linux 5)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

temp tables - readonly user [message #575051]

Fri, 18 January 2013 08:56

candi
Messages: 39
Registered: July 2012

Member

Hi,

There is a readonly user on our reporting server. Developers want to use global temporary tables with this user. I don't want the user to have permissions other than readonly.
I can grant the user CREATE TABLE privilege and did not grant quota on any permanent tablespace, therefore user would not be unable to create permanent tables but still should be able to create global temporary tables.

Question is would a user with such permissions still be able to utilize temp tables as part of a scheduled job?

Thanks

Report message to a moderator

Re: temp tables - readonly user [message #575052 is a reply to message #575051]

Fri, 18 January 2013 08:59

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

as a general rule TEMP table is not necessary & should be avoided.
if GTT is deemed appropriate, them some other schema should CREATE TABLE & GRANT DML to readonly user

Report message to a moderator

Re: temp tables - readonly user [message #575053 is a reply to message #575052]

Fri, 18 January 2013 09:08

candi
Messages: 39
Registered: July 2012

Member

thank you for the very quick reply!

Report message to a moderator

Previous Topic:	Install Oracle 11g software.
Next Topic:	Duplicate database using dpexp and dpimp

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Jan 27 12:37:51 CST 2025