Managing ownerships of fine-grained privacy-preserving columns

A computing system of managing ownerships of fine-grained privacy-preserving columns, 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 catalog table configured to record ownership information of the fine-grained privacy-preserving columns, wherein each of the fine-grained privacy-preserving columns contains secret information, and wherein only an owner of each fine-grained privacy-preserving columns is allowed to execute data control language (DCL) operations associated with each fine-grained privacy-preserving column, wherein the owner of each of the fine-grained privacy-preserving columns is different from a database administrator associated with the catalog table;
• creating a fine-grained privacy-preserving column in response to receiving a first instruction from a first user, wherein the first user is an owner of the fine-grained privacy-preserving column;
• transferring an ownership of the fine-grained privacy-preserving column from the first user to a second user in response to receiving a second instruction from the first user;
• updating the catalog table by inserting a first row into the catalog table in response to detecting a transfer of the ownership of the fine-grained privacy-preserving column to the second user, wherein the first row of the catalog table records information indicating that the first user is a previous owner of the fine-grained privacy-preserving column,
• wherein the operations further comprise:
• receiving a command to revoke the ownership of the fine-grained privacy-preserving column from the second user;
• reverting the ownership of the fine-grained privacy-preserving column back to the first user;
• and
• deleting the first row from the catalog table based on determining that the ownership of the fine-grained privacy-preserving column is reverted back to 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 catalog table configured to record ownership information of the fine-grained privacy-preserving columns, wherein each of the fine-grained privacy-preserving columns contains secret information, and wherein only an owner of each fine-grained privacy-preserving columns is allowed to execute data control language (DCL) operations associated with each fine-grained privacy-preserving column, wherein the owner of each of the fine-grained privacy-preserving columns is different from a database administrator associated with the catalog table;
• creating a fine-grained privacy-preserving column in response to receiving a first instruction from a first user, wherein the first user is an owner of the fine-grained privacy-preserving column;
• transferring an ownership of the fine-grained privacy-preserving column from the first user to a second user in response to receiving a second instruction from the first user;
• updating the catalog table by inserting a first row into the catalog table in response to detecting a transfer of the ownership of the fine-grained privacy-preserving column to the second user, wherein the first row of the catalog table records information indicating that the first user is a previous owner of the fine-grained privacy-preserving column;
• wherein the operations further comprise:
• receiving a command to revoke the ownership of the fine-grained privacy-preserving column from the second user;
• reverting the ownership of the fine-grained privacy-preserving column back to the first user;
• and
• deleting the first row from the catalog table based on determining that the ownership of the fine-grained privacy-preserving column is reverted back to the first user.