--- test +++ upgrade.stable.out @@ -3882,6 +3882,19 @@ JOIN sys.function_types ft ON f.type = ft.function_type_id LEFT OUTER JOIN sys.function_languages fl ON f.language = fl.language_id WHERE s.name <> 'tmp' AND NOT f.system; +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; +GRANT SELECT ON sys.describe_foreign_keys TO PUBLIC; +GRANT SELECT ON sys.describe_tables TO PUBLIC; +GRANT SELECT ON sys.describe_triggers TO PUBLIC; +GRANT SELECT ON sys.describe_comments TO PUBLIC; +GRANT SELECT ON sys.fully_qualified_functions TO PUBLIC; +GRANT SELECT ON sys.describe_privileges TO PUBLIC; +GRANT SELECT ON sys.describe_user_defined_types TO PUBLIC; +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; update sys.functions set system = true where system <> true and name in ('sq', 'fqn', 'get_merge_table_partition_expressions', 'get_remote_table_expressions', 'schema_guard') and schema_id = 2000 and type = 1; update sys._tables set system = true where name in ('describe_constraints', 'describe_tables', 'describe_comments', 'describe_privileges', 'describe_partition_tables', 'describe_functions') AND schema_id = 2000; CREATE VIEW sys.dump_create_roles AS START TRANSACTION;