Re: verify function restriction

Posted by ErmanArslansOracleBlog on Mar 29, 2020; 9:20am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/verify-function-restriction-tp8181p8183.html

You don't need to do any code changes.
This is easy.
Just create a seperate database profile for the accounts other than SYS and other admin users.
Assign the verify function to this new profile.

One profile for middle-tier application schemas (“managed schemas”) and one for human beings. Assign middle-tier application schemas to the profile and all accounts used by individual database administrators to the second profile (maybe just the default profile).