Dropping User
postgres=# drop user tesdb;
Drop role :
postgres=# \du
List of roles
Role name | Attributes | Member of
-----------+------------------------------------------------------------+-----------
postgres | Superuser, Create role, Create DB, Replication, Bypass RLS | {}
tesdbuser | Superuser
Changing Password :
postgres=# alter user tesdbuser with password 'welcome to tesdb';
Alter role:
alter user kri with password 'abcd' valid until '2024-01-19 10:15:00';
« Previous Next Topic » (Assigning privileges to role) |