REVOKE DROP ANY PROCEDURE FROM XXX
를 사용하여 프로시져 드롭 권한을 REVOKE하였으나
여전히 PROCEDURE가 삭제됩니다.;;;
어떤 권한과 충돌이 날 수도 있을까요??
현재 남아 있는 권한은 아래와 같습니다.
ALTER ANY CLUSTER
ALTER ANY INDEX
ALTER ANY OUTLINE
ALTER ANY PROCEDURE
ALTER ANY ROLE
ALTER ANY SEQUENCE
ALTER ANY SNAPSHOT
ALTER ANY TABLE
ALTER ANY TRIGGER
ALTER SESSION
ANALYZE ANY
COMMENT ANY TABLE
CREATE ANY CLUSTER
CREATE ANY CONTEXT
CREATE ANY DIRECTORY
CREATE ANY INDEX
CREATE ANY OUTLINE
CREATE ANY PROCEDURE
CREATE ANY SEQUENCE
CREATE ANY SNAPSHOT
CREATE ANY SYNONYM
CREATE ANY TABLE
CREATE ANY TRIGGER
CREATE ANY VIEW
CREATE DATABASE LINK
CREATE PROCEDURE
CREATE PUBLIC SYNONYM
CREATE ROLE
CREATE SESSION
CREATE SYNONYM
CREATE TRIGGER
CREATE TYPE
CREATE VIEW
DELETE ANY TABLE
DEQUEUE ANY QUEUE
DROP ANY CLUSTER
DROP ANY CONTEXT
DROP ANY INDEX
DROP ANY OUTLINE
DROP ANY ROLE
DROP ANY SEQUENCE
DROP ANY SNAPSHOT
DROP ANY SYNONYM
DROP ANY TABLE
DROP ANY VIEW
DROP PUBLIC SYNONYM
ENQUEUE ANY QUEUE
GLOBAL QUERY REWRITE
GRANT ANY ROLE
INSERT ANY TABLE
LOCK ANY TABLE
MANAGE ANY QUEUE
SELECT ANY DICTIONARY
SELECT ANY SEQUENCE
SELECT ANY TABLE
UNLIMITED TABLESPACE
UPDATE ANY TABLE