Difference between revisions of "ALTER"
Jump to navigation
Jump to search
| (12 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 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> lists default access privilege settings | ||
| + | * [[PostgreSQL meta-commands]] | ||
== See also == | == See also == | ||
| − | * {{ | + | * {{ALTER}} |
| + | * {{GRANT}} | ||
[[Category:PostgreSQL]] | [[Category:PostgreSQL]] | ||
Latest revision as of 08:56, 7 August 2024
ALTER DEFAULT PRIVILEGES IN SCHEMA public GRANT SELECT ON TABLES TO xxx;
ALTER DATABASE
ALTER MATERIALIZED VIEW
Change password[edit]
ALTER USER YOUR_USER WITH PASSWORD 'your_new_password';
Related[edit]
- GRANT SELECT
- Amazon Redshift: grant read only provileges to user
\ddp *.*lists default access privilege settings- PostgreSQL meta-commands
See also[edit]
Advertising:
