Revoke multiple object privileges from PUBLIC
Hello,
in our company we have a oracle policy, in this policy there are defined that the role "PUBLIC" doesn' t hav any privileges.
But at my production and my test database PUBLIC have over 27000 object privileges.
Now i trying to revoke all these object privileges at my test database.
I found a procedure in the web:
begin
for cTab in (select * from SYS.dba_tab_privs where grantee ='PUBLIC') loop
execute immediate 'revoke execute on '||cTab.owner||'.'||cTab.table_name || ' from ' || 'PUBLIC';
end loop;
end;
But i get error message: ora-00903 invalid table name