\dp

From wikieduonline
Revision as of 11:56, 16 December 2022 by Ant (talk | contribs) (→‎Related)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

Lists tables, views and sequences with their associated access privileges:

\dp
\dp *.*


\dp
                                                            Access privileges
Schema |                   Name                   |   Type   |              Access privileges              | Column privileges | Policies
--------+------------------------------------------+----------+---------------------------------------------+-------------------+----------


TABLE (and table-like objects)	arwdDxt	none	\dp


https://www.postgresql.org/docs/9.3/sql-grant.html

rolename=xxxx -- privileges granted to a role
        =xxxx -- privileges granted to PUBLIC

            r -- SELECT ("read")
            w -- UPDATE ("write")
            a -- INSERT ("append")
            d -- DELETE
            D -- TRUNCATE
            x -- REFERENCES
            t -- TRIGGER
            X -- EXECUTE
            U -- USAGE
            C -- CREATE
            c -- CONNECT
            T -- TEMPORARY
      arwdDxt -- ALL PRIVILEGES (for tables, varies for other objects)
            * -- grant option for preceding privilege

        /yyyy -- role that granted this privilege


Related[edit]

See also[edit]

Advertising: