Metadata Visibility

You are looking at an older version of the documentation. The latest version is found here.

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.