1. A grant to grant a role without granting the grant to the role
2. grant select with grant option to system
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;
/
3. Grant Select without Grant Update
5. Is there a way to grant VIEWS ONLY in SQL 2005.
6. Grant two table spaces to a user / Role grants
7. Granting the ability to shadow without granting admin permissi
8. Granting the ability to shadow without granting admin permissions
9. subinacl /subdirectories %SystemDrive% /grant=administrators=f /grant=SYSTEM=f fails
10. subinacl /subdirectories %SystemDrive% /grant=administrators=f /grant=SYSTEM=f Fails
11. Thanks - but no luck with the grant: mysql> grant ALL on *.* to'root'@'10.1.2.
12. granting users Send as permissions causes errors unless they select the FROM address from the GAL
13. permissions granted to user 'NT AUTHORITY\NETWORK SERVICE' are ins
15. Fwd: Ruby Central 2005 Codefest Grant recipients