OraFAQ Forum: Server Administration » Privilege to run dbms

Home » RDBMS Server » Server Administration » Privilege to run dbms_stats package

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

Privilege to run dbms_stats package [message #60526]

Thu, 12 February 2004 05:39

Veera Nallamilli
Messages: 1
Registered: February 2004

Junior Member

What privilege is needed to run dbms_Stats.gather_table_stats

to update table statistics for a different schema ?

I know that I can use either 'sys' or 'system'� ..

�

Thanks

Report message to a moderator

Re: Privilege to run dbms_stats package [message #60528 is a reply to message #60526]

Thu, 12 February 2004 08:37

Thiru
Messages: 1089
Registered: May 2002

Senior Member

"analyze any"

SQL> create user test identified by test default tablespace users;     

User created.

SQL> grant create session,analyze any to test;

Grant succeeded.

SQL> connect test/test
Connected.
SQL> execute dbms_stats.gather_table_stats('SCOTT','EMP');

PL/SQL procedure successfully completed.

-Thiru

Report message to a moderator

Previous Topic:	Very Urgent Help needed - Arabic support in Forms6i& reports6i
Next Topic:	ROWID

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Jan 07 21:13:17 CST 2025