Alex Rivera | Logout

How to quickly drop a user with existing privileges

Asked 2010-06-11T14:26:06.840
201

I'm trying to make restricted DB users for the app I'm working on, and I want to drop the Postgres database user I'm using for experimenting. Is there any way to drop the user without having to revoke all his rights manually first, or revoke all the grants a user has?

database postgresql privileges drop sql-revoke
Edit
Report

1 Answer

21

Also note, if you have explicitly granted:

CONNECT ON DATABASE xxx TO GROUP ,

you will need to revoke this separately from DROP OWNED BY, using:

REVOKE CONNECT ON DATABASE xxx FROM GROUP

answered 2013-03-01T16:17:05.707

Your Answer