Difference between revisions of "\ddp"

From wikieduonline
Jump to navigation Jump to search
Line 16: Line 16:
 
== Related ==
 
== Related ==
 
* <code>[[select schema_name from information_schema.schemata;]]</code>
 
* <code>[[select schema_name from information_schema.schemata;]]</code>
 
+
* <code>[[\dp]]</code>
  
 
== See also ==
 
== See also ==

Revision as of 14:50, 27 April 2022

Lists default access privilege settings


https://dba.stackexchange.com/a/184339

\ddp
                               Default access privileges
       Owner       |   Schema    |   Type   |             Access privileges
-------------------+-------------+----------+-------------------------------------------
 user1   | schema1      | table    | usern1=r/user2
 user2 | schema2   | function | user2=X/user3
 user3 | schema3   | sequence | user2=rwU/user3

Related

See also

Advertising: