PostgreSQL – How to RESET ROLE of a User

ByAdmin

To revert to the original role of the logged in user, you can use the RESET ROLE statement. This will revert to the role of the logged-in user.

Here is the syntax of using the RESET ROLE command:

RESET ROLE;

I’m currently logged in as user ‘postgres’ as shown in the below screenshot:

Using the SET ROLE command, I’m going to assume admin_role as shown below:

I have now switched to admin_role as shown below:

Now, issuing the RESET ROLE command to revert to the original role of ‘postgres’.

Current role can be verified as shown below:

Similar Posts

PostgreSQL – How to List All Databases

ByAdmin

To list all databases in PostgreSQL, you can use the following SQL command: SELECT datname FROM pg_database; Above query will display a list of database names currently available on the server. You should have the necessary permissions to list databases on the PostgreSQL server. If you encounter permission issues, make sure you are logged in…

PostgreSQL – How to Modify log_rotation_size Parameter

ByAdmin

The log_rotation_size parameter determines the size at which PostgreSQL’s log files (usually the log file generated by the pg_log system) will be rotated or switched to a new file. Rotating log files helps postgresql database engine to manage the log file size and prevent them from growing too large, which can be particularly useful for…

PostgreSQL – How to Revoke Superuser Privileges

ByAdmin

To revoke superuser privileges from a user in PostgreSQL, you’ll need to connect to the PostgreSQL database server as a superuser, typically the “postgres” user. Here are the steps to revoke superuser privileges: Log in as the PostgreSQL superuser: Open a terminal and log in as the PostgreSQL superuser, usually named “postgres.” You can do…