Column and row level security in ADPG

To increase the level of protection to database objects, ADPG implements additional security functions for access by authorized users. Access to certain database objects can be allowed or restricted through roles (role-based authentication).

In addition, you can use the GRANT and REVOKE commands to restrict or allow user access.

Objects can be both rows and columns of a table. Such a protection measure is useful if it’s necessary to delimit user access to certain rows or columns in a table, for example, if we don’t want a specific column or row to be seen.