Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Why can't SYS user grant privilege on others' tables?

Re: Why can't SYS user grant privilege on others' tables?

From: Connor McDonald <mcdonald.connor.cs_at_bhp.com.au>
Date: Mon, 12 Apr 1999 10:56:19 +0900
Message-ID: <371160D3.761@bhp.com.au>


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



Connor McDonald
BHP Information Technology
Perth, Western Australia
"Never wrestle a pig - you both get dirty and the pig likes it..." Received on Sun Apr 11 1999 - 20:56:19 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US