FLASHBACK priv missing from ora_privilege_list?
From: Rich Jesse <rjoralist3_at_society.servebeer.com>
Date: Thu, 9 Jan 2014 15:34:37 -0600 (CST)
Message-ID: <efd48bc3ed010633fe20d2484ad09778.squirrel_at_society.servebeer.com>
Hey all,
END;
/
Date: Thu, 9 Jan 2014 15:34:37 -0600 (CST)
Message-ID: <efd48bc3ed010633fe20d2484ad09778.squirrel_at_society.servebeer.com>
Hey all,
In 11.2.0.3, I created a trigger to audit GRANTs to PUBLIC. However, "GRANT ALL ON mytable TO PUBLIC" didn't capture every priv. Using this test trigger:
CREATE OR REPLACE TRIGGER SYS.AUD_GRANT_PUBLIC
AFTER GRANT ON DATABASE
DECLARE
PRAGMA AUTONOMOUS_TRANSACTION; v_user_list DBMS_STANDARD.ora_name_list_t; v_user_count PLS_INTEGER; v_priv_list DBMS_STANDARD.ora_name_list_t; v_priv_count PLS_INTEGER; v_privs VARCHAR2(4000) := ''; BEGIN v_priv_count := ora_privilege_list(v_priv_list); FOR indx IN 1 .. v_priv_count LOOP IF indx > 1 THEN v_privs := v_privs||','; END IF; DBMS_OUTPUT.PUT_LINE(TO_CHAR(indx)||' "'||v_priv_list(indx)||'"'); v_privs := v_privs||v_priv_list(indx); END LOOP;
END;
/
...I found that the "FLASHBACK" priv never appears in the ora_privilege_list table of items. Can anyone else verify this?
I suppose a fudge would be to assume "FLASHBACK" if the v_priv_list(indx) item was null, but I'll never remember to fix that...
Thanks!
Rich
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Jan 09 2014 - 22:34:37 CET