Tagging and auditing sensitive information in a database environment
Access to sensitive information in a database can be restricted to improve security and enable efficient auditing. A security engine receives a request from a requesting entity to access data in the database and determines that the requested data includes sensitive information. In response to the requesting entity being authorized to access the data, the security engine retrieves the requested data from the database and modifies the retrieved data by modifying metadata of the retrieved data to include a tag indicating that the retrieved data includes sensitive information. The security engine provides the modified data to the requesting entity and modifies a data access log to identify each attempted access to the modified data. When sensitive data is requested, an interface can include an obscuring element, requiring a user to manually select the element to view the data, enabling the logging of the explicit access request by the user.
1. A method of restricting a display of data comprising:
displaying, by a security engine, an interface on a client device for displaying one or more sets of non-sensitive information and one or more sets of sensitive information from a database, each of the one or more sets of non-sensitive information to be displayed in a corresponding non-sensitive data field, and each of the one or more sets of sensitive information to be displayed in a corresponding sensitive data field, wherein the one or more sets of sensitive information are not accessed by the security engine upon displaying the interface;
for each of the one or more sets of non-sensitive information, accessing, by the security engine, the set of non-sensitive information from the database and displaying the set of non-sensitive information within the corresponding non-sensitive data field;
for each of the one or more sets of sensitive information:
displaying, by the security engine, a selectable graphical interface element within the interface to at least partially obscure the corresponding sensitive data field; and
in response to receiving a request to view the set of sensitive information, the request comprising a selection of the selectable graphical interface element, and in response to determining that a requesting entity is authorized to view the set of sensitive information:
accessing, by the security engine, the set of sensitive information from the database and displaying the set of sensitive information within the corresponding sensitive data field,
modifying, by the security engine, the interface by removing the selectable graphical interface element from the interface, wherein the corresponding sensitive data field is no longer obscured and at least one other selectable graphical interface element is not removed from the interface, and
modifying, by the security engine, a data access log to identify the request to view the set of sensitive information, the modified data access log identifying the requesting entity, the set of sensitive information, and a time associated with the request to view the set of sensitive information.
2. The method of claim 1 , further comprising:
prior to displaying the interface, determining, by the security engine, that a first set of information to be displayed in a corresponding data field of the interface is sensitive information; and
in response to the determining that the first set of information is sensitive information, identifying the corresponding data field as a sensitive data field.
3. The method of claim 2 , wherein the determining that the first set of information is sensitive information is based on metadata associated with the first set of information.
4. The method of claim 3 , wherein the metadata comprises at least one of:
a category of information, a required authorization level, and a flag indicating that the first set of information corresponds to sensitive information.
5. The method of claim 2 , wherein the determining that the first set of information is sensitive information is based on a format of the first set of information.
6. The method of claim 1 , further comprising:
for each of the one or more sets of sensitive information, in response to determining that the requesting entity is not authorized to view the set of sensitive information, displaying a message in the interface indicating that the requesting entity is not authorized to view the set of sensitive information.
7. The method of claim 6 , wherein for each one of the one or more sets of sensitive information, the set of sensitive information is not accessed from the database in response to determining that the requesting entity is not authorized to view the set of sensitive information.
8. The method of claim 1 , further comprising:
for each of the one or more sets of sensitive information, in response to determining that the requesting entity is not authorized to view the set of sensitive information, initiating, by the security engine, an audit of the modified data access log.
9. The method of claim 1 , wherein the modified data access log further includes information representative of at least one of:
a user account associated with the requesting entity,
a hardware device used by the requesting entity to access sensitive information in the database,
a software application used by the requesting entity to access sensitive information in the database, and
an indication of whether a request to view a set of sensitive information was granted.
10. The method of claim 1 , wherein the modified data access log includes information representative of the interface associated with a request to view the set of sensitive information.
11. The method of claim 10 , wherein the modified data access log further includes information representative of sensitive data fields located within the interface, each of the sensitive data fields corresponding to a request to view a set of sensitive information.
12. The method of claim 1 , wherein the selectable graphical interface element comprises an opaque or semi-opaque box obscuring the data field corresponding to the set of sensitive information.
13. A non-transitory computer readable storage medium storing executable instructions that, when executed by one or more processors, cause the one or more processors to perform steps comprising:
displaying, by a security engine, an interface on a client device for displaying one or more sets of non-sensitive information and one or more sets of sensitive information from a database, each of the one or more sets of non-sensitive information to be displayed in a corresponding non-sensitive data field, and each of the one or more sets of sensitive information to be displayed in a corresponding sensitive data field, wherein the one or more sets of sensitive information are not accessed by the security engine upon displaying the interface fields;
for each of the one or more sets of non-sensitive information, accessing, by the security engine, the set of non-sensitive information from the database and displaying the set of non-sensitive information within the corresponding non-sensitive data field;
for each of the one or more sets of sensitive information:
displaying, by the security engine, a selectable graphical interface element within the interface to at least partially obscure the corresponding sensitive data field; and
in response to receiving a request to view the set of sensitive information, the request comprising a selection of the selectable graphical interface element, and in response to determining that a requesting entity is authorized to view the set of sensitive information:
accessing, by the security engine, the set of sensitive information from the database and displaying the set of sensitive information within the corresponding sensitive data field,
modifying, by the security engine, the interface by removing the selectable graphical interface element from the interface, wherein the corresponding sensitive data field is no longer obscured and at least one other selectable graphical interface element is not removed from the interface, and
modifying, by the security engine, a data access log to identify the request to view the set of sensitive information, the modified data access log identifying the requesting entity, the set of sensitive information, and a time associated with the request to view the set of sensitive information.
14. The non-transitory computer readable storage medium of claim 13 , wherein the selectable graphical interface element comprises an opaque or semi-opaque box obscuring the data field corresponding to the set of sensitive information.
15. The non-transitory computer readable storage medium of claim 13 , wherein the steps further comprise:
for each of the one or more sets of sensitive information, in response to determining that the requesting entity is not authorized to view the set of sensitive information, displaying a message in the interface indicating that the requesting entity is not authorized to view the set of sensitive information.
16. The non-transitory computer readable storage medium of claim 15 , wherein for each of the one or more sets of sensitive information, the set of sensitive information is not accessed from the database in response to determining that the requesting entity is not authorized to view the set of sensitive information.
17. The non-transitory computer readable storage medium of claim 13 , wherein the steps further comprise:
for each of the one or more sets of sensitive information, in response to determining that the requesting entity is not authorized to view the set of sensitive information, initiating, by the security engine, an audit of the modified data access log.
18. The non-transitory computer readable storage medium of claim 13 , wherein the modified data access log includes information representative of the interface associated with a request to view the set of sensitive information.
19. The non-transitory computer readable storage medium of claim 18 , wherein the modified data access log further includes information representative of sensitive data fields located within the interface, each of the sensitive data fields corresponding to a request to view a set of sensitive information.