How to revoke privileged from PostgreSQL's superuser

2018-08-06 Thread bejita0409
Hello,   I am a newbie DBA.   I have a request for revoking the access to user's data from DBA-user. I think the request is right because users should be the only ones can access their data. But DBA-user also need full access to the other data? It means that DBA-user also needs to be a superuser.

Re: Re: How to revoke privileged from PostgreSQL's superuser

2018-08-06 Thread bejita0409
Hi all, Thanks for giving a lot of points of view. I know superuser can not be revoked apart of privileges, because it does not like nosuperusers who's privileges can be made from GRANT statement. As you all mentioned, I will re-check more about our system designation. I am inclined to encry