I have an Oracle Database which includes many users and some of them have DBA roles. The thing is, DBA's shouldn't delete any records from SYS.AUD$ table. Is there a way that i can achieve this?
I have an Oracle Database which includes many users and some of them have DBA roles.
Are they DBAs?
DBAs know better than to "muck about" with the Audit Trail.
If they're not DBAs, then they should not have this Role. Period.
Always keep the biggest and best tools for yourself - so that you can clean up the mess that other people / processes make!
I would suggest immediately starting work on finding another way of providing what these Users [think they] want.