Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Grant with Admin Option

792290Aug 8 2012 — edited Aug 8 2012
I have create a role TD_ADM and would like grant the object privileges such as select, insert, update etc... to TD_ADM role with admin option.

here is grant that i am trying to grant to TD_ADM.

grant select on foo.dept to td_adm with admin option;
i get the ora-00993 error missing grant keyword.
i know we can do for system grants with admin option, but can we do to object privileges?

Thanks....
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 5 2012
Added on Aug 8 2012
1 comment
1,044 views