grant select with grant option to system

From: bonminh lam <hansmayer1962_at_hotmail.com>
Date: 11 Jul 2004 09:29:54 -0700
Message-ID: <3c6b1bcf.0407110829.4992f982@posting.google.com>

Hello,

this is a script I would like to be able to grab from the net no matter where I am and run it as SYS.

Basically so far I always have to log on to the host machine as SYS in case an user XZY happens to need to select from view e.g. V$INSTANCE, am I am getting tired of that.

begin

	for rec in (
		select replace(table_name, 'V$', 'V_$') table_name
		from dict 
		where table_name like 'V$%'
	) loop
		begin
			execute immediate 'grant select on '
                          ||rec.table_name||' to system with grant
option';
			dbms_output.put_line(rec.table_name||' succeeded');
		exception
			when others then
			  dbms_output.put_line(
                            substr('table_name='||rec.table_name
                              ||' '||sqlcode||' '||sqlerrm, 1, 255));
		end;
	end loop;

end;
/ Received on Sun Jul 11 2004 - 11:29:54 CDT