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 Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.gravatar.com/avatar/becf189cf1f1c059ee2d59973ab96492?s=64&d=mm&r=g) |
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
|
|
|
|
|
|
|
|