Changeset: b03d5e39417f for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/b03d5e39417f Modified Files: sql/scripts/10_sys_schema_extension.sql Branch: userprofile Log Message:
don't user db_users anymore. diffs (12 lines): diff --git a/sql/scripts/10_sys_schema_extension.sql b/sql/scripts/10_sys_schema_extension.sql --- a/sql/scripts/10_sys_schema_extension.sql +++ b/sql/scripts/10_sys_schema_extension.sql @@ -506,7 +506,7 @@ GRANT SELECT ON sys.privilege_codes TO P -- Utility view to list the defined roles. -- Note: sys.auths contains both users and roles as the names must be distinct. -CREATE VIEW sys.roles AS SELECT id, name, grantor FROM sys.auths a WHERE a.name NOT IN (SELECT u.name FROM sys.db_users() u); +CREATE VIEW sys.roles AS SELECT id, name, grantor FROM sys.auths a WHERE a.name NOT IN (SELECT u.name FROM sys.users u); GRANT SELECT ON sys.roles TO PUBLIC; _______________________________________________ checkin-list mailing list -- [email protected] To unsubscribe send an email to [email protected]
