Metadata Visibility
You can show or hide all objects (schemas, tables, views, procedures and columns) in metadata using role permissions.
The object is shown if the user has a role with:
R
permission for a data source, schema, table, view, table, or view column;E
permission for a procedure.
The object is hidden if the user has a role with permission for the object and this permission does not have:
R
permission for a data source, schema, table, view, table, or view column;E
permission for a procedure.
Here are several examples:
1. Hiding the pg_test_tables
data source:
SYSADMIN.setPermissions('user_role', '*', 'CRUDEAL');;
SYSADMIN.setPermissions('user_role', 'pg_test_tables', '');;
2. Showing the pg_test_tables
data source and hide the test_table_1
table:
SYSADMIN.setPermissions('user_role', 'pg_test_tables ', 'CRUDEAL');;
SYSADMIN.setPermissions('user_role', 'pg_test_tables.test_table_1', '');;
3. Hiding the test_proc_1
procedure in test_schema
:
SYSADMIN.setPermissions('user_role', '*', 'CRUDEAL');;
SYSADMIN.setPermissions('user_role', 'test_schema.test_proc_1', '');;
4. Hiding the col_1
column in test_view_1
view:
SYSADMIN.setPermissions('user_role', '*', 'CRUDEAL');;
SYSADMIN.setPermissions('user_role', 'test_schema.test_view_1.col_1', '');;
Please note that visibility inheritance, transitivity, and permission overlap; please refer to Permissions for more detail.