Home » RDBMS Server » Server Administration » temp tables - readonly user (10.2.0.4.0, RH Linux 5)
temp tables - readonly user [message #575051] Fri, 18 January 2013 08:56 Go to next message
candi
Messages: 30
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
Re: temp tables - readonly user [message #575052 is a reply to message #575051] Fri, 18 January 2013 08:59 Go to previous messageGo to next message
BlackSwan
Messages: 22481
Registered: January 2009
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
Re: temp tables - readonly user [message #575053 is a reply to message #575052] Fri, 18 January 2013 09:08 Go to previous message
candi
Messages: 30
Registered: July 2012
Member
thank you for the very quick reply!
Previous Topic: Install Oracle 11g software.
Next Topic: Duplicate database using dpexp and dpimp
Goto Forum:
  


Current Time: Wed Jul 23 00:59:19 CDT 2014

Total time taken to generate the page: 0.11311 seconds