Implementing password resetting control in a database containing secret information

A system of implementing password resetting control in a database containing secret information, comprising:

• at least one processor;
• and
• at least one memory communicatively coupled to the at least one processor and comprising computer-readable instructions that upon execution by the at least one processor cause the at least one processor to perform operations comprising:
• creating a control column in a database user catalog table, wherein the control column comprises a variable configured to restrict an authority of a privileged user to reset passwords for owners or viewers of privacy-preserving columns, wherein the privacy-preserving columns contain the secret information, wherein the variable is a binary variable, and wherein a default setting of the variable has a first value;
• receiving a first instruction of granting a first user as an owner or a viewer of a first privacy-preserving column, wherein the first privacy-preserving column is any of the privacy-preserving columns;
• and
• automatically switching a value of the variable corresponding to the first user from the first value to a second value in response to determining that the first user is granted as the owner or the viewer for a first time, wherein the first value of the variable indicates that the privileged user has the authority to reset a password for the first user, and wherein the second value of the variable indicates that the privileged user lacks the authority to reset the password for the first user.

A non-transitory computer-readable storage medium, storing computer-readable instructions that upon execution by a processor cause the processor to implement operations comprising:

• creating a control column in a database user catalog table, wherein the control column comprises a variable configured to restrict an authority of a privileged user to reset passwords for owners or viewers of privacy-preserving columns, wherein the privacy-preserving columns contain the secret information, wherein the variable is a binary variable, and wherein a default setting of the variable has a first value;
• receiving a first instruction of granting a first user as an owner or a viewer of a first privacy-preserving column, wherein the first privacy-preserving column is any of the privacy-preserving columns;
• and
• automatically switching a value of the variable corresponding to the first user from the first value to a second value in response to determining that the first user is granted as the owner or the viewer for a first time, wherein the first value of the variable indicates that the privileged user has the authority to reset a password for the first user, and wherein the second value of the variable indicates that the privileged user lacks the authority to reset the password for the first user.