Database Administrator

In regular object-based auditing, the records can show that a user selected from a specific table, along with other helpful information such...

if you want to track password change or other activity with sql then ALTER SYSTEM SET AUDIT_TRAIL=DB_EXTENDED SCOPE=SPFILE; THERE IS SQ...

CREATE TABLE DBA_AUDIT_TAB_KSH (USERNAME VARCHAR2(10), SQL_TEXT VARCHAR2(2000),TIMESTAMP DATE); CREATE OR REPLACE TRIGGER DBA_AUDIT_KSH BEFO...

select name,value from v$parameter where name='audit_trail'; ALTER SYSTEM SET AUDIT_TRAIL=DB SCOPE=SPFILE; Shutdown startup -- selec...

select username,osuser,machine,blocking_session from v$session where username='LDBO'; select username,os_username,to_char(timestamp,...