Changeset: 9f2c097ce4f2 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=9f2c097ce4f2
Modified Files:
sql/backends/monet5/sql_upgrades.c
sql/test/emptydb-upgrade-chain-hge/Tests/upgrade.stable.out.int128
sql/test/emptydb-upgrade-chain-hge/Tests/upgrade.stable.out.ppc64.int128
sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out
sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.32bit
sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.int128
sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.ppc64
sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.ppc64.int128
sql/test/emptydb-upgrade-hge/Tests/upgrade.stable.out.int128
sql/test/emptydb-upgrade/Tests/upgrade.stable.out.32bit
sql/test/emptydb-upgrade/Tests/upgrade.stable.out.int128
sql/test/testdb-upgrade-chain-hge/Tests/upgrade.stable.out.int128
sql/test/testdb-upgrade-chain/Tests/upgrade.stable.out
sql/test/testdb-upgrade-chain/Tests/upgrade.stable.out.32bit
sql/test/testdb-upgrade-chain/Tests/upgrade.stable.out.int128
sql/test/testdb-upgrade-hge/Tests/upgrade.stable.out.int128
sql/test/testdb-upgrade/Tests/upgrade.stable.out
sql/test/testdb-upgrade/Tests/upgrade.stable.out.32bit
sql/test/testdb-upgrade/Tests/upgrade.stable.out.int128
Branch: default
Log Message:
Don't grant users view to the public
diffs (209 lines):
diff --git a/sql/backends/monet5/sql_upgrades.c
b/sql/backends/monet5/sql_upgrades.c
--- a/sql/backends/monet5/sql_upgrades.c
+++ b/sql/backends/monet5/sql_upgrades.c
@@ -2780,7 +2780,6 @@ sql_update_default(Client c, mvc *sql, c
"SELECT u.\"name\" AS \"name\",
ui.\"fullname\", ui.\"default_schema\", ui.\"schema_path\"\n"
" FROM db_users() AS u\n"
" LEFT JOIN \"sys\".\"db_user_info\" AS
ui ON u.\"name\" = ui.\"name\";\n"
- "GRANT SELECT ON sys.users TO PUBLIC;\n"
"CREATE VIEW
sys.dependency_schemas_on_users AS\n"
" SELECT s.id AS schema_id, s.name AS
schema_name, u.name AS user_name, CAST(6 AS smallint) AS depend_type\n"
" FROM sys.users AS u, sys.schemas AS
s\n"
diff --git a/sql/test/emptydb-upgrade-chain-hge/Tests/upgrade.stable.out.int128
b/sql/test/emptydb-upgrade-chain-hge/Tests/upgrade.stable.out.int128
--- a/sql/test/emptydb-upgrade-chain-hge/Tests/upgrade.stable.out.int128
+++ b/sql/test/emptydb-upgrade-chain-hge/Tests/upgrade.stable.out.int128
@@ -4393,7 +4393,6 @@ CREATE VIEW sys.users AS
SELECT u."name" AS "name", ui."fullname", ui."default_schema", ui."schema_path"
FROM db_users() AS u
LEFT JOIN "sys"."db_user_info" AS ui ON u."name" = ui."name";
-GRANT SELECT ON sys.users TO PUBLIC;
CREATE VIEW sys.dependency_schemas_on_users AS
SELECT s.id AS schema_id, s.name AS schema_name, u.name AS user_name, CAST(6
AS smallint) AS depend_type
FROM sys.users AS u, sys.schemas AS s
diff --git
a/sql/test/emptydb-upgrade-chain-hge/Tests/upgrade.stable.out.ppc64.int128
b/sql/test/emptydb-upgrade-chain-hge/Tests/upgrade.stable.out.ppc64.int128
--- a/sql/test/emptydb-upgrade-chain-hge/Tests/upgrade.stable.out.ppc64.int128
+++ b/sql/test/emptydb-upgrade-chain-hge/Tests/upgrade.stable.out.ppc64.int128
@@ -4393,7 +4393,6 @@ CREATE VIEW sys.users AS
SELECT u."name" AS "name", ui."fullname", ui."default_schema", ui."schema_path"
FROM db_users() AS u
LEFT JOIN "sys"."db_user_info" AS ui ON u."name" = ui."name";
-GRANT SELECT ON sys.users TO PUBLIC;
CREATE VIEW sys.dependency_schemas_on_users AS
SELECT s.id AS schema_id, s.name AS schema_name, u.name AS user_name, CAST(6
AS smallint) AS depend_type
FROM sys.users AS u, sys.schemas AS s
diff --git a/sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out
b/sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out
--- a/sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out
+++ b/sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out
@@ -3798,7 +3798,6 @@ CREATE VIEW sys.users AS
SELECT u."name" AS "name", ui."fullname", ui."default_schema", ui."schema_path"
FROM db_users() AS u
LEFT JOIN "sys"."db_user_info" AS ui ON u."name" = ui."name";
-GRANT SELECT ON sys.users TO PUBLIC;
CREATE VIEW sys.dependency_schemas_on_users AS
SELECT s.id AS schema_id, s.name AS schema_name, u.name AS user_name, CAST(6
AS smallint) AS depend_type
FROM sys.users AS u, sys.schemas AS s
diff --git a/sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.32bit
b/sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.32bit
--- a/sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.32bit
+++ b/sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.32bit
@@ -3798,7 +3798,6 @@ CREATE VIEW sys.users AS
SELECT u."name" AS "name", ui."fullname", ui."default_schema", ui."schema_path"
FROM db_users() AS u
LEFT JOIN "sys"."db_user_info" AS ui ON u."name" = ui."name";
-GRANT SELECT ON sys.users TO PUBLIC;
CREATE VIEW sys.dependency_schemas_on_users AS
SELECT s.id AS schema_id, s.name AS schema_name, u.name AS user_name, CAST(6
AS smallint) AS depend_type
FROM sys.users AS u, sys.schemas AS s
diff --git a/sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.int128
b/sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.int128
--- a/sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.int128
+++ b/sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.int128
@@ -4467,7 +4467,6 @@ CREATE VIEW sys.users AS
SELECT u."name" AS "name", ui."fullname", ui."default_schema", ui."schema_path"
FROM db_users() AS u
LEFT JOIN "sys"."db_user_info" AS ui ON u."name" = ui."name";
-GRANT SELECT ON sys.users TO PUBLIC;
CREATE VIEW sys.dependency_schemas_on_users AS
SELECT s.id AS schema_id, s.name AS schema_name, u.name AS user_name, CAST(6
AS smallint) AS depend_type
FROM sys.users AS u, sys.schemas AS s
diff --git a/sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.ppc64
b/sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.ppc64
--- a/sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.ppc64
+++ b/sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.ppc64
@@ -3798,7 +3798,6 @@ CREATE VIEW sys.users AS
SELECT u."name" AS "name", ui."fullname", ui."default_schema", ui."schema_path"
FROM db_users() AS u
LEFT JOIN "sys"."db_user_info" AS ui ON u."name" = ui."name";
-GRANT SELECT ON sys.users TO PUBLIC;
CREATE VIEW sys.dependency_schemas_on_users AS
SELECT s.id AS schema_id, s.name AS schema_name, u.name AS user_name, CAST(6
AS smallint) AS depend_type
FROM sys.users AS u, sys.schemas AS s
diff --git
a/sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.ppc64.int128
b/sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.ppc64.int128
--- a/sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.ppc64.int128
+++ b/sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.ppc64.int128
@@ -4467,7 +4467,6 @@ CREATE VIEW sys.users AS
SELECT u."name" AS "name", ui."fullname", ui."default_schema", ui."schema_path"
FROM db_users() AS u
LEFT JOIN "sys"."db_user_info" AS ui ON u."name" = ui."name";
-GRANT SELECT ON sys.users TO PUBLIC;
CREATE VIEW sys.dependency_schemas_on_users AS
SELECT s.id AS schema_id, s.name AS schema_name, u.name AS user_name, CAST(6
AS smallint) AS depend_type
FROM sys.users AS u, sys.schemas AS s
diff --git a/sql/test/emptydb-upgrade-hge/Tests/upgrade.stable.out.int128
b/sql/test/emptydb-upgrade-hge/Tests/upgrade.stable.out.int128
--- a/sql/test/emptydb-upgrade-hge/Tests/upgrade.stable.out.int128
+++ b/sql/test/emptydb-upgrade-hge/Tests/upgrade.stable.out.int128
@@ -4393,7 +4393,6 @@ CREATE VIEW sys.users AS
SELECT u."name" AS "name", ui."fullname", ui."default_schema", ui."schema_path"
FROM db_users() AS u
LEFT JOIN "sys"."db_user_info" AS ui ON u."name" = ui."name";
-GRANT SELECT ON sys.users TO PUBLIC;
CREATE VIEW sys.dependency_schemas_on_users AS
SELECT s.id AS schema_id, s.name AS schema_name, u.name AS user_name, CAST(6
AS smallint) AS depend_type
FROM sys.users AS u, sys.schemas AS s
diff --git a/sql/test/emptydb-upgrade/Tests/upgrade.stable.out.32bit
b/sql/test/emptydb-upgrade/Tests/upgrade.stable.out.32bit
--- a/sql/test/emptydb-upgrade/Tests/upgrade.stable.out.32bit
+++ b/sql/test/emptydb-upgrade/Tests/upgrade.stable.out.32bit
@@ -3798,7 +3798,6 @@ CREATE VIEW sys.users AS
SELECT u."name" AS "name", ui."fullname", ui."default_schema", ui."schema_path"
FROM db_users() AS u
LEFT JOIN "sys"."db_user_info" AS ui ON u."name" = ui."name";
-GRANT SELECT ON sys.users TO PUBLIC;
CREATE VIEW sys.dependency_schemas_on_users AS
SELECT s.id AS schema_id, s.name AS schema_name, u.name AS user_name, CAST(6
AS smallint) AS depend_type
FROM sys.users AS u, sys.schemas AS s
diff --git a/sql/test/emptydb-upgrade/Tests/upgrade.stable.out.int128
b/sql/test/emptydb-upgrade/Tests/upgrade.stable.out.int128
--- a/sql/test/emptydb-upgrade/Tests/upgrade.stable.out.int128
+++ b/sql/test/emptydb-upgrade/Tests/upgrade.stable.out.int128
@@ -4467,7 +4467,6 @@ CREATE VIEW sys.users AS
SELECT u."name" AS "name", ui."fullname", ui."default_schema", ui."schema_path"
FROM db_users() AS u
LEFT JOIN "sys"."db_user_info" AS ui ON u."name" = ui."name";
-GRANT SELECT ON sys.users TO PUBLIC;
CREATE VIEW sys.dependency_schemas_on_users AS
SELECT s.id AS schema_id, s.name AS schema_name, u.name AS user_name, CAST(6
AS smallint) AS depend_type
FROM sys.users AS u, sys.schemas AS s
diff --git a/sql/test/testdb-upgrade-chain-hge/Tests/upgrade.stable.out.int128
b/sql/test/testdb-upgrade-chain-hge/Tests/upgrade.stable.out.int128
--- a/sql/test/testdb-upgrade-chain-hge/Tests/upgrade.stable.out.int128
+++ b/sql/test/testdb-upgrade-chain-hge/Tests/upgrade.stable.out.int128
@@ -4393,7 +4393,6 @@ CREATE VIEW sys.users AS
SELECT u."name" AS "name", ui."fullname", ui."default_schema", ui."schema_path"
FROM db_users() AS u
LEFT JOIN "sys"."db_user_info" AS ui ON u."name" = ui."name";
-GRANT SELECT ON sys.users TO PUBLIC;
CREATE VIEW sys.dependency_schemas_on_users AS
SELECT s.id AS schema_id, s.name AS schema_name, u.name AS user_name, CAST(6
AS smallint) AS depend_type
FROM sys.users AS u, sys.schemas AS s
diff --git a/sql/test/testdb-upgrade-chain/Tests/upgrade.stable.out
b/sql/test/testdb-upgrade-chain/Tests/upgrade.stable.out
--- a/sql/test/testdb-upgrade-chain/Tests/upgrade.stable.out
+++ b/sql/test/testdb-upgrade-chain/Tests/upgrade.stable.out
@@ -3798,7 +3798,6 @@ CREATE VIEW sys.users AS
SELECT u."name" AS "name", ui."fullname", ui."default_schema", ui."schema_path"
FROM db_users() AS u
LEFT JOIN "sys"."db_user_info" AS ui ON u."name" = ui."name";
-GRANT SELECT ON sys.users TO PUBLIC;
CREATE VIEW sys.dependency_schemas_on_users AS
SELECT s.id AS schema_id, s.name AS schema_name, u.name AS user_name, CAST(6
AS smallint) AS depend_type
FROM sys.users AS u, sys.schemas AS s
diff --git a/sql/test/testdb-upgrade-chain/Tests/upgrade.stable.out.32bit
b/sql/test/testdb-upgrade-chain/Tests/upgrade.stable.out.32bit
--- a/sql/test/testdb-upgrade-chain/Tests/upgrade.stable.out.32bit
+++ b/sql/test/testdb-upgrade-chain/Tests/upgrade.stable.out.32bit
@@ -3798,7 +3798,6 @@ CREATE VIEW sys.users AS
SELECT u."name" AS "name", ui."fullname", ui."default_schema", ui."schema_path"
FROM db_users() AS u
LEFT JOIN "sys"."db_user_info" AS ui ON u."name" = ui."name";
-GRANT SELECT ON sys.users TO PUBLIC;
CREATE VIEW sys.dependency_schemas_on_users AS
SELECT s.id AS schema_id, s.name AS schema_name, u.name AS user_name, CAST(6
AS smallint) AS depend_type
FROM sys.users AS u, sys.schemas AS s
diff --git a/sql/test/testdb-upgrade-chain/Tests/upgrade.stable.out.int128
b/sql/test/testdb-upgrade-chain/Tests/upgrade.stable.out.int128
--- a/sql/test/testdb-upgrade-chain/Tests/upgrade.stable.out.int128
+++ b/sql/test/testdb-upgrade-chain/Tests/upgrade.stable.out.int128
@@ -4467,7 +4467,6 @@ CREATE VIEW sys.users AS
SELECT u."name" AS "name", ui."fullname", ui."default_schema", ui."schema_path"
FROM db_users() AS u
LEFT JOIN "sys"."db_user_info" AS ui ON u."name" = ui."name";
-GRANT SELECT ON sys.users TO PUBLIC;
CREATE VIEW sys.dependency_schemas_on_users AS
SELECT s.id AS schema_id, s.name AS schema_name, u.name AS user_name, CAST(6
AS smallint) AS depend_type
FROM sys.users AS u, sys.schemas AS s
diff --git a/sql/test/testdb-upgrade-hge/Tests/upgrade.stable.out.int128
b/sql/test/testdb-upgrade-hge/Tests/upgrade.stable.out.int128
--- a/sql/test/testdb-upgrade-hge/Tests/upgrade.stable.out.int128
+++ b/sql/test/testdb-upgrade-hge/Tests/upgrade.stable.out.int128
@@ -4393,7 +4393,6 @@ CREATE VIEW sys.users AS
SELECT u."name" AS "name", ui."fullname", ui."default_schema", ui."schema_path"
FROM db_users() AS u
LEFT JOIN "sys"."db_user_info" AS ui ON u."name" = ui."name";
-GRANT SELECT ON sys.users TO PUBLIC;
CREATE VIEW sys.dependency_schemas_on_users AS
SELECT s.id AS schema_id, s.name AS schema_name, u.name AS user_name, CAST(6
AS smallint) AS depend_type
FROM sys.users AS u, sys.schemas AS s
diff --git a/sql/test/testdb-upgrade/Tests/upgrade.stable.out
b/sql/test/testdb-upgrade/Tests/upgrade.stable.out
--- a/sql/test/testdb-upgrade/Tests/upgrade.stable.out
+++ b/sql/test/testdb-upgrade/Tests/upgrade.stable.out
@@ -3798,7 +3798,6 @@ CREATE VIEW sys.users AS
SELECT u."name" AS "name", ui."fullname", ui."default_schema", ui."schema_path"
FROM db_users() AS u
LEFT JOIN "sys"."db_user_info" AS ui ON u."name" = ui."name";
-GRANT SELECT ON sys.users TO PUBLIC;
CREATE VIEW sys.dependency_schemas_on_users AS
SELECT s.id AS schema_id, s.name AS schema_name, u.name AS user_name, CAST(6
AS smallint) AS depend_type
FROM sys.users AS u, sys.schemas AS s
diff --git a/sql/test/testdb-upgrade/Tests/upgrade.stable.out.32bit
b/sql/test/testdb-upgrade/Tests/upgrade.stable.out.32bit
--- a/sql/test/testdb-upgrade/Tests/upgrade.stable.out.32bit
+++ b/sql/test/testdb-upgrade/Tests/upgrade.stable.out.32bit
@@ -3798,7 +3798,6 @@ CREATE VIEW sys.users AS
SELECT u."name" AS "name", ui."fullname", ui."default_schema", ui."schema_path"
FROM db_users() AS u
LEFT JOIN "sys"."db_user_info" AS ui ON u."name" = ui."name";
-GRANT SELECT ON sys.users TO PUBLIC;
CREATE VIEW sys.dependency_schemas_on_users AS
SELECT s.id AS schema_id, s.name AS schema_name, u.name AS user_name, CAST(6
AS smallint) AS depend_type
FROM sys.users AS u, sys.schemas AS s
diff --git a/sql/test/testdb-upgrade/Tests/upgrade.stable.out.int128
b/sql/test/testdb-upgrade/Tests/upgrade.stable.out.int128
--- a/sql/test/testdb-upgrade/Tests/upgrade.stable.out.int128
+++ b/sql/test/testdb-upgrade/Tests/upgrade.stable.out.int128
@@ -4467,7 +4467,6 @@ CREATE VIEW sys.users AS
SELECT u."name" AS "name", ui."fullname", ui."default_schema", ui."schema_path"
FROM db_users() AS u
LEFT JOIN "sys"."db_user_info" AS ui ON u."name" = ui."name";
-GRANT SELECT ON sys.users TO PUBLIC;
CREATE VIEW sys.dependency_schemas_on_users AS
SELECT s.id AS schema_id, s.name AS schema_name, u.name AS user_name, CAST(6
AS smallint) AS depend_type
FROM sys.users AS u, sys.schemas AS s
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list
