GRANT error in SQL 2005: GRANT SELECT ON sysprocesses TO PUBLI

GRANT error in SQL 2005: GRANT SELECT ON sysprocesses TO PUBLI

Post by QWxleCBDV » Sun, 30 Jan 2005 04:31:05


I tried USE <DBNAME> and I receive the same error.

sysprocesses is a system view, in the 'sys' Schema.
Another idea?
 
 
 

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

4. MS SQL 2005. GRANT.

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

14. Coordination 2005: Grants

15. Fwd: Ruby Central 2005 Codefest Grant recipients