Which system privileges are being used
Hi,
I want to monitor which system privileges specific accounts are using. We have many legacy/old applications which have Oracle accounts (Oracle 19c.20 Enterprise Edition) with too many privileges (imo). Some have even dba roles assigned.
Normally I assign privs like create table, create view , create procedure, etc to schema owners. Certainly not a dba roles.
So I would like to check over a period of time which system privs a session used and based on that assign only the privs needed.
regards,
Ivan