@@ -54,8 +54,8 @@ CREATE VIEW viewperms_v7 AS SELECT * FROM viewperms_v2;
5454-- v2pgslq
5555-- v3tuser
5656-- v4tuser
57- -- v5pgsql
58- -- v6pgsql
57+ -- v5postgres
58+ -- v6postgres
5959-- v7tuser
6060--
6161UPDATE pg_classSET relowner= viewperms_testid()
@@ -71,31 +71,31 @@ UPDATE pg_class SET relowner = viewperms_testid()
7171-- Now for the tests.
7272--
7373
74- -- View v1 ownerpgsql has access to t1 owned by tuser
74+ -- View v1 ownerpostgres has access to t1 owned by tuser
7575SELECT * FROM viewperms_v1;
7676
77- -- View v2 ownerpgsql has access to t2 owned bypgsql (of cause)
77+ -- View v2 ownerpostgres has access to t2 owned bypostgres (of cause)
7878SELECT * FROM viewperms_v2;
7979
8080-- View v3 owner tuser has access to t1 owned by tuser
8181SELECT * FROM viewperms_v3;
8282
83- -- View v4 owner tuser has NO access to t2 owned bypgsql
83+ -- View v4 owner tuser has NO access to t2 owned bypostgres
8484-- MUST fail with permission denied
8585SELECT * FROM viewperms_v4;
8686
87- -- v5 (pgsql ) can access v2 (pgsql ) can access t1 (tuser)
87+ -- v5 (postgres ) can access v2 (postgres ) can access t1 (tuser)
8888SELECT * FROM viewperms_v5;
8989
90- -- v6 (pgsql ) can access v4 (tuser) CANNOT access t2 (pgsql )
90+ -- v6 (postgres ) can access v4 (tuser) CANNOT access t2 (postgres )
9191SELECT * FROM viewperms_v6;
9292
93- -- v7 (tuser) CANNOT access v2 (pgsql ) wanna access t2 (pgslq)
93+ -- v7 (tuser) CANNOT access v2 (postgres ) wanna access t2 (pgslq)
9494SELECT * FROM viewperms_v7;
9595
9696GRANT SELECT ON viewperms_v2 TO PUBLIC;
9797-- but now
98- -- v7 (tuser) can access v2 (pgsql via grant) can access t2 (pgsql )
98+ -- v7 (tuser) can access v2 (postgres via grant) can access t2 (postgres )
9999SELECT * FROM viewperms_v7;
100100
101101--