Admin option to Sys Account on all objects - How?

From: badri <badri_at_cc.gatech.edu>
Date: 1996/04/15
Message-ID: <4kv040$hga_at_gaia.cc.gatech.edu>#1/1


Hi:

        I am using sys account to grant priveleges from one schema to another. ORACLE gives me the error "Insufficient Privileges". I have to login as the owner of the object to grant privileges to another schema/role. Does the sys account not come with defult admin option on all objects? How would I grant admin option to sys without doing it on an object-by-object basis from each account?

thanks a lot,

-Badri Received on Mon Apr 15 1996 - 00:00:00 CEST

Original text of this message