Grant with Admin Option
792290Aug 8 2012 — edited Aug 8 2012I 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....