Проверка прав доступа

Листинг 8.2. Проверка прав доступа

testdb=# SELECT relname as "Relation", relacl as "Access permissions"

testdb-# FROM pg_class

testdb-# WHERE relkind IN Cr', 'V. 'S')

testdb-# AND relname !- '*pg_'

testdb-# ORDER BY relname;

Relation I Access permissions

foo {"=arwR"."jdrake=arwR"}

myjlist {"=","jdrake=arwR"."jworsley=r"}

(2 rows)