OraFAQ Forum: Security » Differenece between grant all on any table and grant all on table

Home » RDBMS Server » Security » Differenece between grant all on any table and grant all on table_name (Oracle,11g,Linux)

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

Differenece between grant all on any table and grant all on table_name [message #569674]

Wed, 31 October 2012 03:05

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

Report message to a moderator

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

Michel Cadot
Messages: 68732
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

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

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

Report message to a moderator

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

Michel Cadot
Messages: 68732
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

It depends on what you mean with this (invalid) statement.

Regards
Michel

Report message to a moderator

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

John Watson
Messages: 8964
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.

Report message to a moderator

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

Michel Cadot
Messages: 68732
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

And I wonder why Oracle has delivered such statement. The only excuse is it is in the standard.

Regards
Michel

Report message to a moderator

Previous Topic:	oracle wallet creation and accessing
Next Topic:	automatic generated grants on sys_plsql_xxxx_yy_z

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Feb 01 21:31:03 CST 2025