grant option for system tables in V7.0

From: Gary Stephens <stephens_at_sse.ie>
Date: Tue, 5 Jul 1994 10:46:00 GMT
Message-ID: <CsGr8r.G14_at_sse.ie>

In Oracle V6.0, running on the Siemens Nixdorf SINIX 5.41 operating system, i can do the following :

    create view gary as select * from table_privileges;     grant select on gary to public;

with no problems.

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'

Is this a change in V7.0 (i can't find anything in the manuals about it), or is it a problem with Oracle on AIX ? Does anyone know ?

thanks in advance,

Gary
gary.stephens_at_sse.ie Received on Tue Jul 05 1994 - 12:46:00 CEST