Difference between revisions of "ALTER DEFAULT PRIVILEGES"

From wikieduonline
Jump to navigation Jump to search
 
(One intermediate revision by one other user not shown)
Line 3: Line 3:
 
  [[ALTER]] DEFAULT PRIVILEGES IN [[SCHEMA]] public [[GRANT SELECT ON TABLES]] TO xxx;
 
  [[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 ==
 
== See also ==

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: