1

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?

0

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

`GRANT A TO B;`

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

  • The only cons are that this way you cannot drop A without B losing the privileges, there are other attributes besides superuser, and B can now impersonate A. – dezso Jun 1 '18 at 15:23
  • You also can't drop A without reassigning his ownerships some other user, so that may nt be such a big problem. – Jasen Jun 3 '18 at 23:01
  • Common privileges can override owner privileges? – Tatiana Jun 4 '18 at 8:01
  • How can i solve this? – Tatiana Jun 13 '18 at 9:13
  • Common privileges can override owner privileges? @Tatiana. I'm not sure, but what do you see when you have try it ? – Steve Ruben Jun 13 '18 at 9:25

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.