vpruthi/doc-exports
1
0
Fork 0
forked from docs/doc-exports
Code Pull Requests Activity
doc-exports/docs/dws/umn/dws_03_0095.html
Lu, Huayi c5fcb46315 DWS UMN 801 version 
Reviewed-by: Hasko, Vladimir <vladimir.hasko@t-systems.com>
Co-authored-by: Lu, Huayi <luhuayi@huawei.com>
Co-committed-by: Lu, Huayi <luhuayi@huawei.com>
2022-12-13 12:47:57 +00:00

3.1 KiB
Raw Permalink Blame History

How Do I View All Database Users and Their Permissions?

  • To view the user list, query the PG_USER view.
    1
2
    	
SELECT * FROM pg_user;
  • To view user attributes, query the PG_AUTHID system catalog.
    1
2
    	
SELECT * FROM pg_authid;
  • Query the permissions of user joe.
    1
    SELECT * FROM pg_authid where rolname = 'joe';