We have the following scenario...
We've inherited a situation where we have a master admin user that's used across the board for all processes.
We need to undo that one process at a time. So, for each process we thought of creating two secondary users, among which we will rotate a password.
However, since a PostgreSQL Db cannot have more than one owner then these secondary users cannot act on the DB objects the same way, that is our understanding.
The question is, if a DB already has an owner that we want to keep as the owner for now, can we create an equivalent user that will effectively have the same behaviour as the owner while not being the owner?
And, will any objects created by this new user be fully accessible by the original master user?
Thanks