Difference between revisions of "ALTER DEFAULT PRIVILEGES"

From wikieduonline
Jump to navigation Jump to search
(Redirected page to ALTER)
Tag: New redirect
 
 
(5 intermediate revisions by one other user not shown)
Line 1: Line 1:
#redirect [[ALTER]]
+
* https://www.postgresql.org/docs/current/sql-alterdefaultprivileges.html
 +
 
 +
[[ALTER]] DEFAULT PRIVILEGES IN [[SCHEMA]] public [[GRANT SELECT ON TABLES]] TO xxx;
 +
 
 +
ALTER DEFAULT PRIVILEGES
 +
    [ FOR { ROLE | USER } target_role [, ...] ]
 +
    [ IN SCHEMA schema_name [, ...] ]
 +
 
 +
 
 +
== Related ==
 +
* [[GRANT]]
 +
 
 +
== See also ==
 +
* {{Alter}}
 +
 
 +
[[Category:SQL]]

Latest revision as of 15:39, 5 July 2023

ALTER DEFAULT PRIVILEGES IN SCHEMA public GRANT SELECT ON TABLES TO xxx;
ALTER DEFAULT PRIVILEGES
    [ FOR { ROLE | USER } target_role [, ...] ]
    [ IN SCHEMA schema_name [, ...] ]


Related[edit]

See also[edit]

Advertising: