Changeset: 1e50ea753be4 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/1e50ea753be4 Modified Files: sql/scripts/52_describe.sql Branch: default Log Message:
Adds a view on accessible tables for the current role in sql scripts diffs (35 lines): diff --git a/sql/scripts/52_describe.sql b/sql/scripts/52_describe.sql --- a/sql/scripts/52_describe.sql +++ b/sql/scripts/52_describe.sql @@ -601,6 +601,26 @@ BEGIN WHERE f.name=functionName AND s.name = schemaName; END; +CREATE VIEW sys.describe_accessible_tables AS + SELECT + schemas.name AS schema, + tables.name AS table, + table_types.table_type_name AS table_type, + privilege_codes.privilege_code_name AS privs, + privileges.privileges AS privs_code + FROM privileges + JOIN sys.roles + ON privileges.auth_id = roles.id + JOIN sys.tables + ON privileges.obj_id = tables.id + JOIN sys.table_types + ON tables.type = table_types.table_type_id + JOIN sys.schemas + ON tables.schema_id = schemas.id + JOIN sys.privilege_codes + ON privileges.privileges = privilege_codes.privilege_code_id + WHERE roles.name = current_role; + GRANT SELECT ON sys.describe_constraints TO PUBLIC; GRANT SELECT ON sys.describe_indices TO PUBLIC; GRANT SELECT ON sys.describe_column_defaults TO PUBLIC; @@ -614,3 +634,4 @@ GRANT SELECT ON sys.describe_user_define GRANT SELECT ON sys.describe_partition_tables TO PUBLIC; GRANT SELECT ON sys.describe_sequences TO PUBLIC; GRANT SELECT ON sys.describe_functions TO PUBLIC; +GRANT SELECT ON sys.describe_accessible_tables TO PUBLIC; _______________________________________________ checkin-list mailing list -- checkin-list@monetdb.org To unsubscribe send an email to checkin-list-le...@monetdb.org