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,

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-l
Received on Thu Jan 09 2014 - 22:34:37 CET

Original text of this message