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
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