grant option for system tables in V7.0

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

Under O7, you need special synonyms to access the SYS.* tables. Gotta run catdbsyn.sql to setup the correct synonyms.

This is assuming that the table (or view) is still there. The data dictionary is a moving picture, changing with each release of Oracle. Never trust things to stay the same between releases. I've got all kinds of housekeeping scripts that were obsoleted when moving from O6->O7, some of with was replaced by the new SQL-DBA, others that had to be re-written. Received on Tue Jul 05 1994 - 16:03:00 CEST