Search Postgresql Archives

Re: Trouble DROP'ing a ROLE, despite REVOKE'ing its privileges

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Dominique Devienne <ddevienne@xxxxxxxxx> writes:
> Final step is to DROP the "owner" ROLE itself, but before doing that,
> I run REVOKE ALL ON DATABASE "ddevienne" FROM "owner".

That will only revoke privileges that were granted by the role
doing the REVOKE, so I surmise that you did this as some other role.
But actually capturing the DB's privileges at the point where the
DROP ROLE is failing would help you debug.

			regards, tom lane





[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux