grant select with grant option to system

grant select with grant option to system

Post by hansmayer1 » Tue, 13 Jul 2004 01:29:54


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;
/
 
 
 

grant select with grant option to system

Post by Michel Cad » Tue, 13 Jul 2004 04:06:56


"bonminh lam" < XXXX@XXXXX.COM > a rit dans le message de


Grant select_catalog_role to XYZ.