Skip to main content
Skip table of contents

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:

SQL
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:

SQL
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:

SQL
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:

SQL
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.


JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.