# \[question\] postgresql\_privs\_module: REVOKE CREATE ON schema public FROM \[user\]

**URL:** <https://forum.ansible.com/t/question-postgresql-privs-module-revoke-create-on-schema-public-from-user/33550>\
**Category:** Ansible Project\
**Created:** [August 4, 2020, 3:36pm UTC](https://forum.ansible.com/t/question-postgresql-privs-module-revoke-create-on-schema-public-from-user/33550 "2020-08-04T15:36:58Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![Bob2](https://avatars.discourse-cdn.com/v4/letter/b/848f3c/32.png) [@Bob2](https://forum.ansible.com/u/Bob2)\
**Post date:** [August 4, 2020, 3:36pm UTC](https://forum.ansible.com/t/question-postgresql-privs-module-revoke-create-on-schema-public-from-user/33550/1 "2020-08-04T15:36:58Z")

</div>

Hi folks,

How can I write the following simple PostgreSQL outcome?

REVOKE CREATE ON schema public FROM [user]

I’m using:

- Module: [https://docs.ansible.com/ansible/latest/modules/postgresql\_privs\_module.html](https://docs.ansible.com/ansible/latest/modules/postgresql_privs_module.html)

- Ansible 2.9.7

After searching the docs and web, I couldn’t figure out the settings.

Would be great if somebody has the answer.