Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- select o.*
- from sys_object o,
- SYS_AU_ACTION a,
- SYS_AU_ACTION_TYPE ac
- where a.ACTION_TYPE_ID = ac.id
- and ac.ident in ('UPDATE_OBJECT', 'CREATE_OBJECT')
- and a.user_id in ('800', '1')
- and a.stamp between '2019-08-01' and '2019-09-01'
- and o.id = a.obj_id
- group by o.id;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement