# Postgresql revoke user privileges on views

**URL:** <https://forum.ansible.com/t/postgresql-revoke-user-privileges-on-views/17749>\
**Category:** Ansible Project\
**Created:** [March 16, 2015, 11:28am UTC](https://forum.ansible.com/t/postgresql-revoke-user-privileges-on-views/17749 "2015-03-16T11:28:19Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![Maxwell\_Talbot](https://avatars.discourse-cdn.com/v4/letter/m/47e85d/32.png) [@Maxwell\_Talbot](https://forum.ansible.com/u/Maxwell_Talbot)\
**Post date:** [March 16, 2015, 11:28am UTC](https://forum.ansible.com/t/postgresql-revoke-user-privileges-on-views/17749/1 "2015-03-16T11:28:19Z")

</div>

Hi All,

I’m having some trouble removing users using the postgresql\_user integration module, I accept that I’m probably doing something dumb.

To get rid of users, I realise I need to first get rid of their privileges. I successfully revoke table and sequence privileges

Unfortunately I’ve not figured out (or found out) how to remove privileges on views, which still kick around and prevent deletion or the user account

trying to delete the user manually shows:

drop user max;

ERROR: role “max” cannot be dropped because some objects depend on it

DETAIL: privileges for privileges for view best\_test\_view

any help with this would be great happy to provide more info if needed