Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Why can't SYS user grant privilege on others' tables?
pradyumn_sharma_at_hotmail.com wrote:
>
> * Using Personal Oracle7, release 7.2.2.3.1. I log on as
> sys/change_on_install, and give the following command:
>
> SQL> grant select on pradyumn.x to system;
> grant select on pradyumn.x to system
> *
> ERROR at line 1:
> ORA-01031: insufficient privileges
>
> Why so?
>
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
SYS can get around it by creating a procedure which issues the grant
using dbms_sql in the schema that owns the object, running that proc and
then dropping it.
--