create table SCOTT.DDL_LOG
(
ORA_SYSEVENT VARCHAR2(4000),
ORA_DICT_OBJ_OWNER VARCHAR2(4000),
ORA_LOGIN_USER VARCHAR2(4000),
ORA_DICT_OBJ_TYPE VARCHAR2(4000),
ORA_DICT_OBJ_NAME VARCHAR2(4000),
USERR VARCHAR2(30),
DAT DATE,
PROGRAM VARCHAR2(64),
OSUSER VARCHAR2(30)
)
CREATE OR REPLACE TRIGGER TR_audit
AFTER CREATE ON SCHEMA
BEGIN
INSERT INTO SCOTT.DDL_LOG
SELECT ora_sysevent, ora_dict_obj_owner,ORA_LOGIN_USER,ORA_DICT_OBJ_TYPE,
ora_dict_obj_name,USER userr, SYSDATE dat FROM dual ;
END TR_audit;
Here my DBA will not grant scott.ddl_log to my schema 'TEST' .How can I use AUTHID CURRENT_USER
Thanks in Advance .