Personal,
I am doubtful how to perform these 2 selects:
1) Owner trigger audit without any option marked: Before Insert / Delete / Update.
2) Owner trigger deactivated or invalid audit.
grateful.
Select from triggers
-
- Moderador
- Posts: 1396
- Joined: Fri, 01 Feb 2008 2:06 pm
- Location: Rio de Janeiro - RJ
- Contact:

select *
from all_objects
where owner = 'SYS'
and status = 'VALID'
and object_type = 'TRIGGER'
select *
from all_objects
where owner = 'SYS'
and status = 'VALID'
and object_type = 'TRIGGER'
Why is the Owner's 'SYS'?
How would the command be to return the invalid or disabled?
And the triggers with some unchecked option (Before Update, Insert, Delete)?
grateful.
-
- Moderador
- Posts: 1396
- Joined: Fri, 01 Feb 2008 2:06 pm
- Location: Rio de Janeiro - RJ
- Contact:

face ..
I just gave you the way .. who has to tread and you ...
I just gave you the way .. who has to tread and you ...
owner = 'AUDITORIA' --não sei a qual usuario pertencem as triggers de auditoria
status <> 'VALID' -- era so trocar de igual apra diferente
-
- Moderador
- Posts: 1396
- Joined: Fri, 01 Feb 2008 2:06 pm
- Location: Rio de Janeiro - RJ
- Contact:

select * from all_triggers where status <> 'ENABLED'
2) It was right:
select TRIGGER_NAME,STATUS
from dba_triggers
where owner = 'TCU'
and status = 'DISABLED'
union all
select OBJECT_NAME,STATUS
from all_objects
where owner ='TCU'
and status ='INVALID'
and object_type = 'TRIGGER'
-
- Information
-
Who is online
Users browsing this forum: No registered users and 1 guest