Granting privileges to a schema to a role
| От | Johnson, Bruce E - (bjohnson) |
|---|---|
| Тема | Granting privileges to a schema to a role |
| Дата | |
| Msg-id | 93A9C6E2-01A7-47C4-8A71-26EC122D25F6@arizona.edu обсуждение исходный текст |
| Список | pgsql-general |
psql webdata -U trav
psql (15.4 (Ubuntu 15.4-1.pgdg22.04+1))
Type "help" for help.
webdata=> \dp trav.sectors
Access privileges
Schema | Name | Type | Access privileges | Column privileges | Policies
--------+---------+-------+-------------------------+-------------------+----------
trav | sectors | table | webdata=arwdDxt/webdata+| |
| | | trav=arwdDxt/webdata | |
(1 row)
webdata=> select sectorname, count(worldname) from trav.sectors group by sectorname order by sectorname;
ERROR: permission denied for schema trav
LINE 1: select sectorname, count(worldname) from trav.sectors group ...
Bruce Johnson
University of Arizona
College of Pharmacy
Information Technology Group
Institutions do not have opinions, merely customs
В списке pgsql-general по дате отправления: