revokeany.sql

来自「Oracle PL/SQL procedure generator (secon」· SQL 代码 · 共 7 行

revoke create any procedure from &1;
revoke alter any procedure from &1;
revoke execute any procedure from &1;
REVOKE SELECT ANY TABLE FROM &1;
REVOKE CREATE PUBLIC SYNONYM FROM &1;
REVOKE DROP PUBLIC SYNONYM FROM &1;