Home » RDBMS Server » Security » Differenece between grant all on any table and grant all on table_name (Oracle,11g,Linux)
Differenece between grant all on any table and grant all on table_name [message #569674] Wed, 31 October 2012 03:05 Go to next message
rjocmc
Messages: 14
Registered: December 2011
Junior Member
Dear Sir

I am a beginner in Oracle database..

I would like to know what happens when we fire:

grant all on any table to user_name;

and

grant all on table_name to user_name;

Actually I was performing "grant all on table_name to user_name;" to grant the privilege but 1 of my friends suggested "grant all on any table to user_name;"

Please help me..

Thanks & Regards

Rijo
Re: Differenece between grant all on any table and grant all on table_name [message #569675 is a reply to message #569674] Wed, 31 October 2012 03:07 Go to previous messageGo to next message
Michel Cadot
Messages: 59791
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
SQL> grant all on any table to michel;
grant all on any table to michel
             *
ERROR at line 1:
ORA-00903: invalid table name

Does this answer the question?

Regards
Michel
Re: Differenece between grant all on any table and grant all on table_name [message #569679 is a reply to message #569675] Wed, 31 October 2012 04:10 Go to previous messageGo to next message
rjocmc
Messages: 14
Registered: December 2011
Junior Member
Dear Sir

Thanks for the acknowledgment.

So what would be the alternative grant statement for this : grant all on any table to michel;

Thanks & Regards

Rijo
Re: Differenece between grant all on any table and grant all on table_name [message #569681 is a reply to message #569679] Wed, 31 October 2012 04:55 Go to previous messageGo to next message
Michel Cadot
Messages: 59791
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
It depends on what you mean with this (invalid) statement.

Regards
Michel
Re: Differenece between grant all on any table and grant all on table_name [message #569691 is a reply to message #569681] Wed, 31 October 2012 05:54 Go to previous messageGo to next message
John Watson
Messages: 4803
Registered: January 2010
Location: Global Village
Senior Member
There is a grant,
GRANT ALL PRIVILEGES TO....
that (in my 11.2.0.3) grants 200 system privileges to the user so he can then do just about anything. I wasn't aware of this before. I don't think I shall ever use it.
Re: Differenece between grant all on any table and grant all on table_name [message #569692 is a reply to message #569691] Wed, 31 October 2012 06:16 Go to previous message
Michel Cadot
Messages: 59791
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
And I wonder why Oracle has delivered such statement. The only excuse is it is in the standard.

Regards
Michel
Previous Topic: oracle wallet creation and accessing
Next Topic: automatic generated grants on sys_plsql_xxxx_yy_z
Goto Forum:
  


Current Time: Wed Nov 26 12:57:27 CST 2014

Total time taken to generate the page: 0.13125 seconds