There is a database owner, I need to add another user with the same privileges. With rights to update/delete/alter, etc.
How can I do it?
Postgresql – How add user with same privileges
permissionspostgresql
Related Question
- PostgreSQL Privileges – Database Owner and Application User
- SQL Server Permissions – Granting Permissions to an Entire Schema vs. Object
- PostgreSQL Permissions – Implicit Privileges for Schema Owner
- SQL Server – Cannot Find User Due to Non-Existence or Lack of Permission
- PostgreSQL – How to Grant Privileges as Superuser
Best Answer
you can create an user and add all privileges trough grant command or you can just create a role and grant all privileges your role have to the new created role
It will grant all right of role A to B.
If A is a superuser, you also need: ALTER USER B WITH SUPERUSER;
reference link1 and link2