This question has been flagged
1 Reply
2222 Views

Hi. Can somebody help me? it turns out that deactivating users deactivates the managed user and now I can not enter with this user and is the only one with all the privileges. I have access to root (super user). How do I activate the Admin?

Avatar
Discard
Best Answer

Please be aware that deactivating users does not deactivate the admin account. Only deactivating the admin account does deactivate the admin account.

You can try to reactivate the admin user (user with ID 1) directly in the database:

~$  sudo su postgres
~$ psql
postgres=# \connect Your_Database_Name
You are now connected to database "Your_database_Name" as user "postgres"
YOurDatabase_Name=# UPDATE res_users SET active=True WHERE id=1;

This should do the trick.

Avatar
Discard