Difference between revisions of "\ddp"

From wikieduonline
Jump to navigation Jump to search
(Created page with " Default access privileges Owner | Schema | Type | Access privileges -------------------+-------------+-...")
 
 
(14 intermediate revisions by 2 users not shown)
Line 1: Line 1:
 +
\ddp
 +
\ddp *.*
 +
 +
Lists [[default access privilege]] settings
 +
 +
* https://www.postgresql.org/docs/14/app-psql.html
 +
 +
 +
https://dba.stackexchange.com/a/184339
 +
 +
\ddp
 
                                 Default access privileges
 
                                 Default access privileges
 
         Owner      |  Schema    |  Type  |            [[Access privileges]]
 
         Owner      |  Schema    |  Type  |            [[Access privileges]]
Line 5: Line 16:
 
   user2 | schema2  | [[function]] | user2=X/user3
 
   user2 | schema2  | [[function]] | user2=X/user3
 
   user3 | schema3  | [[sequence]] | user2=rwU/user3
 
   user3 | schema3  | [[sequence]] | user2=rwU/user3
 +
 +
 +
\ddp
 +
The server (version 8.0) does not support altering default privileges.
 +
 +
 +
== Related ==
 +
* <code>[[select schema_name from information_schema.schemata;]]</code>
 +
* <code>[[\dp]]</code>
 +
* [[ALTER DEFAULT PRIVILEGES]]
 +
* [[PostgreSQL meta-commands]]
 +
 +
== See also ==
 +
* {{GRANT}}
 +
* {{psql}}
 +
 +
[[Category:PostgreSQL]]

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: