Changeset: cc3734126825 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/cc3734126825
Modified Files:
sql/scripts/76_dump.sql
sql/test/sql_dump/Tests/dump.test
Branch: userprofile
Log Message:
fix dump user script
diffs (26 lines):
diff --git a/sql/scripts/76_dump.sql b/sql/scripts/76_dump.sql
--- a/sql/scripts/76_dump.sql
+++ b/sql/scripts/76_dump.sql
@@ -16,7 +16,7 @@ CREATE VIEW sys.dump_create_users AS
SELECT
'CREATE USER ' || sys.dq(ui.name) || ' WITH ENCRYPTED PASSWORD ' ||
sys.sq(sys.password_hash(ui.name)) ||
- ' NAME ' || sys.sq(ui.fullname) || ' SCHEMA sys' ||
ifthenelse(ui.schema_path = '"sys"', '', ' SCHEMA PATH ' ||
sys.sq(ui.schema_path)) || ';' stmt,
+ ' NAME ' || sys.sq(ui.fullname) || ' SCHEMA ' || sys.sq(s.name) || '
SCHEMA PATH ' || sys.sq(ui.schema_path) || ';' stmt,
ui.name user_name
FROM sys.db_user_info ui, sys.schemas s
WHERE ui.default_schema = s.id
diff --git a/sql/test/sql_dump/Tests/dump.test
b/sql/test/sql_dump/Tests/dump.test
--- a/sql/test/sql_dump/Tests/dump.test
+++ b/sql/test/sql_dump/Tests/dump.test
@@ -285,8 +285,8 @@ SELECT stmt FROM sys.dump_database(FALSE
START TRANSACTION;
SET SCHEMA "sys";
CREATE ROLE "king";
-CREATE USER "voc" WITH ENCRYPTED PASSWORD
'ea45cf4e124b215a28631ec7ff0bf06e82fc26b2be7a066c9594855690fb5d42438be58d6523132384a1738cb4e5139caa1f970ebdfb422d65834d9a4ef61c0e'
NAME 'VOC Explorer' SCHEMA sys;
-CREATE USER "voc2" WITH ENCRYPTED PASSWORD
'ea45cf4e124b215a28631ec7ff0bf06e82fc26b2be7a066c9594855690fb5d42438be58d6523132384a1738cb4e5139caa1f970ebdfb422d65834d9a4ef61c0e'
NAME 'VOC Explorer' SCHEMA sys;
+CREATE USER "voc" WITH ENCRYPTED PASSWORD
'ea45cf4e124b215a28631ec7ff0bf06e82fc26b2be7a066c9594855690fb5d42438be58d6523132384a1738cb4e5139caa1f970ebdfb422d65834d9a4ef61c0e'
NAME 'VOC Explorer' SCHEMA sys SCHEMA PATH '"voc"';
+CREATE USER "voc2" WITH ENCRYPTED PASSWORD
'ea45cf4e124b215a28631ec7ff0bf06e82fc26b2be7a066c9594855690fb5d42438be58d6523132384a1738cb4e5139caa1f970ebdfb422d65834d9a4ef61c0e'
NAME 'VOC Explorer' SCHEMA sys SCHEMA PATH '"voc2"';
CREATE SCHEMA "sbar" AUTHORIZATION "monetdb";
CREATE SCHEMA "sfoo" AUTHORIZATION "monetdb";
CREATE TYPE "sfoo"."json" EXTERNAL NAME "json";
_______________________________________________
checkin-list mailing list -- [email protected]
To unsubscribe send an email to [email protected]
