Difference between revisions of "ALTER"
Jump to navigation
Jump to search
(5 intermediate revisions by 2 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]] | ||
+ | |||
+ | === [[Change password]] === | ||
+ | [[ALTER USER]] YOUR_USER WITH PASSWORD 'your_new_password'; | ||
== Related == | == Related == | ||
Line 6: | Line 10: | ||
* [[Amazon Redshift: grant read only provileges to user]] | * [[Amazon Redshift: grant read only provileges to user]] | ||
* <code>[[\ddp]] *.*</code> lists default access privilege settings | * <code>[[\ddp]] *.*</code> lists default access privilege settings | ||
+ | * [[PostgreSQL meta-commands]] | ||
== See also == | == See also == |
Revision as of 14:13, 16 March 2023
ALTER DEFAULT PRIVILEGES IN SCHEMA public GRANT SELECT ON TABLES TO xxx;
ALTER DATABASE
Change password
ALTER USER YOUR_USER WITH PASSWORD 'your_new_password';
Related
- GRANT SELECT
- Amazon Redshift: grant read only provileges to user
\ddp *.*
lists default access privilege settings- PostgreSQL meta-commands
See also
Advertising: