Hi,
We are working on Oracle Database 19c Enterprise Edition 19.12.0.
In our application, every user has their own account to login to the application, through which login to the database with their own credentials. All users are certain roles and system privileges. Problem here is all users have "Execute any procedure" system privilege directly and it is needed to work on the application. I want to restrict this privilege and should set only for applications and shouldn't set for SQL Plus/Toad.
Can I achieve this requirement through logon triggers? Please help me.
Thanks a lot for the help.