Difference between revisions of "ALTER USER"
Jump to navigation
Jump to search
| Line 7: | Line 7: | ||
[[ALTER USER myuser WITH SUPERUSER;]] | [[ALTER USER myuser WITH SUPERUSER;]] | ||
Error: must be [[superuser]] to alter superusers | Error: must be [[superuser]] to alter superusers | ||
| + | |||
| + | [[ALTER USER]] airflow_user [[SET]] [[search_path]] = [[public]]; | ||
Revision as of 18:06, 19 December 2022
https://www.postgresql.org/docs/8.0/sql-alteruser.html ALTER USER YOUR_USER WITH PASSWORD 'your_new_password'; ALTER_ROLE
ALTER USER "YOUR_USER" CREATEDB;
ALTER USER myuser WITH SUPERUSER; Error: must be superuser to alter superusers
ALTER USER airflow_user SET search_path = public;
Related terms
See also
ALTER, ALTER DATABASE, ALTER DEFAULT PRIVILEGES- PostgreSQL: Database roles,
CREATE USER,CREATE ROLE,\du, \du+,create user, Alter user GRANT,\ddp,GRANT USAGE,GRANT ALL PRIVILEGES,GRANT SELECT, View GRANTs on Redshift,has_table_privilege,has_schema_privilege,HAS_DATABASE_PRIVILEGE,SCHEMA, Privileges,GRANT EXECUTE
Advertising:
