I figured it out.
User_1 should be granted "grant any object privilege" .
-Ancy

-----Original Message-----
From: Chandrasekhar Rao Dharmapurinagaraja
[mailto:[Email address protected]
Sent: Friday, January 27, 2006 12:38 PM
To: Mathews Ansamma
Subject: RE: Question on GRANT

**A LazyDBA.com subscriber has responded to your lazydba.com post**
**LazyDBA.com mail shield has forwarded you this email, **and removed
any attachments, and kept your email address secret **from this person,
and any viruses/trojans.
**If you reply to this email, the person will see your email address as
normal **Anything below this line is the original email text


Hi,

As far as I know, in oracle, unless a user owns or has been granted
object privileges by the real owner of the table, one cannot grant
object privileges on a table that belongs to others, even if he has DBA
privileges

Regards,



-----Original Message-----
From: Mathews Ansamma
[Email address protected]
Sent: Friday, January 27, 2006 11:58 PM
To: LazyDBA Discussion
Subject: Question on GRANT

Hi,
I have a user user_1 with "create any table" & select any table with
admin option".

However, when user_1 tries to grant select table privileges to a table
another schema to a user, it give me an error of insufficient
privileges.


SQL > grant select on user_2.test_table to web_read_usr ; ERROR at line
1:
ORA-01031: insufficient privileges

I tried granting "grant any privilege" to user_1 but that didn't make
difference.

What system privilege I should give to user_1 to make my mission
successful?

Thanks,
Ancy


--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com To unsubscribe:
see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com By using this list you agree
to these terms:http://www.lazydba.com/legal.html




Oracle LazyDBA home page