Home » RDBMS Server » Security » privileges for stats (ORACLE 11GR2 SOLARIS)
privileges for stats [message #565216] Fri, 31 August 2012 11:14 Go to next message
guddu_12
Messages: 124
Registered: April 2012
Location: UK
Senior Member
Hi

My tables are in ers_stg schema and code which collects state on these table are in etls_ers schema, what permission i need in order to get the stats collected from etls_srs schema. i am getting in sufficient priv error

Rajesh

Report message to a moderator

Re: privileges for stats [message #565217 is a reply to message #565216] Fri, 31 August 2012 11:26 Go to previous message
Michel Cadot
Messages: 54226
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
ANALYZE ANY as said in the documentation.

Regards
Michel

Report message to a moderator

Previous Topic: how to generate user and password manually
Next Topic: PassWord encryption and decryption
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri May 24 05:07:59 CDT 2013

Total time taken to generate the page: 0.11016 seconds
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.