This article is half-done without your Comment! *** Please share your thoughts via Comment ***
In this post, I am sharing a script for transforming normal DB user to Super User in PostgreSQL.
The Super User is the admin user and it has all kind of access to PostgreSQL Server. We can create multiple superusers in PostgreSQL.
I need this kind of handy commands/scripts because when any new dba join the team, giving basic permission of database and later the same user requires superuser permission.
Convert a user into Super User:
|
1 |
ALTER USER user_name WITH SUPERUSER; |
Revoke Super User Permission:
|
1 |
ALTER USER user_name WITH NOSUPERUSER; |
Leave a Reply