Difference between revisions of "\ddp"

From wikieduonline
Jump to navigation Jump to search
 
(One intermediate revision by one other user not shown)
Line 2: Line 2:
 
  \ddp *.*
 
  \ddp *.*
  
Lists default access privilege settings
+
Lists [[default access privilege]] settings
  
 
* https://www.postgresql.org/docs/14/app-psql.html
 
* https://www.postgresql.org/docs/14/app-psql.html
Line 26: Line 26:
 
* <code>[[\dp]]</code>
 
* <code>[[\dp]]</code>
 
* [[ALTER DEFAULT PRIVILEGES]]
 
* [[ALTER DEFAULT PRIVILEGES]]
 +
* [[PostgreSQL meta-commands]]
  
 
== See also ==
 
== See also ==

Latest revision as of 13:38, 23 November 2022

\ddp
\ddp *.*

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


\ddp
The server (version 8.0) does not support altering default privileges.


Related[edit]

See also[edit]

Advertising: