Re: grant option for system tables in V7.0
From: Jgreene <jgreene_at_aol.com>
Date: 5 Jul 1994 20:24:02 -0400
Message-ID: <2vctj2$8u9_at_search01.news.aol.com>
> create view gary as select * from table_privileges;
> grant select on gary to public;
Date: 5 Jul 1994 20:24:02 -0400
Message-ID: <2vctj2$8u9_at_search01.news.aol.com>
In article <CsGr8r.G14_at_sse.ie>, stephens_at_sse.ie (Gary Stephens) writes:
> But in Oracle V7.0, running on AIX 3.2, i get the following :
^^^^ ^^^^^^^
> create view gary as select * from table_privileges;
> grant select on gary to public;
> ORA-01720: grant option does not exist for
'SYS.TABLE_PRIVILEGES'
It looks like perhaps the user granting the access (perhaps a user
with DBA privileges) has select but was not given the grant option
(i.e. the privilege to grant his/her privileges to other users). Try
doing the same thing as system or sys.
Received on Wed Jul 06 1994 - 02:24:02 CEST