Re: grant option for system tables in V7.0

Gary Stephens (stephens_at_sse.ie) wrote:

: 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

	In Oracle6, most of the system tables were owned by SYSTEM who
	also had the GRANT OPTION, so as long as you were logged in as
	SYSTEM and executed your commands, it worked fine.

	On Oracle7, most of the system tables are now owned by SYS and
	even SYSTEM needs to run the dba_syn.sql script to access these
	tables as views.  So SYSTEM does not have GRANT OPTION to grant
	others to read the underlying table, even though he/she owns the
	view created on it.

	The solution to your problem is to log in as SYS and regrant the
	privelege to SYSTEM with GRANT OPTION; then when you log in as
	SYSTEM and create your views, you can now grant permissions on
	the view, knowing that you have the GRANT OPTION on the underlying
	table.

	Arshad
	Arshad.Noor_at_mail.citicorp.com