Yanor.net/
Wiki
Blog
GitHub
Sandbox
開始行:
* テーブルへのアクセス権限の確認 [#bbc9b7c1]
** \l で確認する [#da7e683c]
postgres=> \l
List of databases
Name | Owner | Encoding | Collate | Ctyp...
-----------+----------+----------+-------------+--------...
postgres | postgres | UTF8 | en_US.UTF-8 | en_US.U...
template0 | postgres | UTF8 | en_US.UTF-8 | en_US.U...
| | | | ...
template1 | postgres | UTF8 | en_US.UTF-8 | en_US.U...
| | | | ...
- 権限の内容は以下のドキュメントにあるが、分かりづらい
- https://www.postgresql.org/docs/12/ddl-priv.html#PRIVIL...
** information_schema の role_table_grants で確認する [#n...
PSQL> \connect my_db
PSQL> SELECT grantee, table_name, privilege_type FROM in...
grantee | table_name | privilege_type
---------+------------+----------------
user_01 | orders | INSERT
user_01 | orders | SELECT
user_01 | orders | UPDATE
user_01 | orders | DELETE
user_01 | orders | TRUNCATE
user_01 | orders | REFERENCES
user_01 | orders | TRIGGER
user_01 | members | INSERT
user_01 | members | SELECT
user_01 | members | UPDATE
- granteeがユーザ名(=ロール名)
** 参考 [#q15c96f9]
https://dba.stackexchange.com/questions/4286/list-the-dat...
終了行:
* テーブルへのアクセス権限の確認 [#bbc9b7c1]
** \l で確認する [#da7e683c]
postgres=> \l
List of databases
Name | Owner | Encoding | Collate | Ctyp...
-----------+----------+----------+-------------+--------...
postgres | postgres | UTF8 | en_US.UTF-8 | en_US.U...
template0 | postgres | UTF8 | en_US.UTF-8 | en_US.U...
| | | | ...
template1 | postgres | UTF8 | en_US.UTF-8 | en_US.U...
| | | | ...
- 権限の内容は以下のドキュメントにあるが、分かりづらい
- https://www.postgresql.org/docs/12/ddl-priv.html#PRIVIL...
** information_schema の role_table_grants で確認する [#n...
PSQL> \connect my_db
PSQL> SELECT grantee, table_name, privilege_type FROM in...
grantee | table_name | privilege_type
---------+------------+----------------
user_01 | orders | INSERT
user_01 | orders | SELECT
user_01 | orders | UPDATE
user_01 | orders | DELETE
user_01 | orders | TRUNCATE
user_01 | orders | REFERENCES
user_01 | orders | TRIGGER
user_01 | members | INSERT
user_01 | members | SELECT
user_01 | members | UPDATE
- granteeがユーザ名(=ロール名)
** 参考 [#q15c96f9]
https://dba.stackexchange.com/questions/4286/list-the-dat...
ページ名: