Difference between revisions of "ALTER"

From wikieduonline
Jump to navigation Jump to search
 
(10 intermediate revisions by 3 users not shown)
Line 1: Line 1:
  [[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]] USER YOUR_USER WITH PASSWORD 'your_new_password';
+
 
 +
[[ALTER DATABASE]]
 +
 
 +
  [[ALTER MATERIALIZED VIEW]]
 +
 
 +
=== [[Change password]] ===
 +
[[ALTER USER]] YOUR_USER WITH PASSWORD 'your_new_password';
  
 
== Related ==
 
== Related ==
 
* [[GRANT SELECT]]
 
* [[GRANT SELECT]]
 
* [[Amazon Redshift: grant read only provileges to user]]
 
* [[Amazon Redshift: grant read only provileges to user]]
* <code>[[\ddp]]</code>
+
* <code>[[\ddp]] *.*</code> lists default access privilege settings
 +
* [[PostgreSQL meta-commands]]
  
 
== See also ==
 
== See also ==
* {{PostgreSQL}}
+
* {{ALTER}}
 +
* {{GRANT}}
  
 
[[Category:PostgreSQL]]
 
[[Category:PostgreSQL]]

Latest revision as of 08:56, 7 August 2024

Advertising: