File: ex18.sql

package info (click to toggle)
pgformatter 5.9-1
  • links: PTS, VCS
  • area: main
  • in suites: forky, sid
  • size: 7,964 kB
  • sloc: sql: 186,493; perl: 5,694; makefile: 2; sh: 1
file content (13 lines) | stat: -rw-r--r-- 353 bytes parent folder | download | duplicates (5) 
1
2
3
4
5
6
7
8
9
10
11
12
13
 
GRANT SELECT, INSERT, UPDATE, DELETE ON ALL TABLES IN SCHEMA foo TO role_bar, role_baz;

SELECT * FROM t WHERE a IS NOT DISTINCT FROM b;

-- Deploy schemas/custom/grants/grant_schema_to_authenticated to pg
-- requires: schemas/custom/schema
BEGIN;

	GRANT USAGE ON SCHEMA custom
TO authenticated;
GRANT USAGE ON SCHEMA custom TO authenticated;

COMMIT;