When multiple users using the same login account database, the DBA usually don't allow the user to change password, so how to prevent the user change password?

CodePudding user response:

This requirement is quite rare
Who normally don't go to literally change password, unless you are a malicious user
Online search for the ALTER USER statement, can write system trigger is prohibited

CodePudding user response:

You can create a trigger, when users view password change triggers the trigger, the trigger determine whether the user is ordinary users or system administrators in the system or sys user, respectively corresponding to perform different operations,