Provide select access to future objects
8 views
Skip to first unread message
jitendra kumar singh
May 20, 2020, 4:51:11 PM5/20/20
to Ansible Project
Hi,
I am using ansible-playbook to create a dev user which should have only read access in PostgreSQL but after creating dev user, the user is able to perform DML commands within his user scope and also not able to read to future objects or tables means the dev user can't access the tables created from root user. How I can restrict dev user to create/insert/update/delete and other DML commands and allow to access future objects. This is what I am using:
I am using ansible-playbook to create a dev user which should have only read access in PostgreSQL but after creating dev user, the user is able to perform DML commands within his user scope and also not able to read to future objects or tables means the dev user can't access the tables created from root user. How I can restrict dev user to create/insert/update/delete and other DML commands and allow to access future objects. This is what I am using:
- database: testDB
grant_option: no
objs: ALL_IN_SCHEMA
state: present
privs: select
type: table
role: read_only_role
Dick Visser
May 20, 2020, 6:12:38 PM5/20/20
to ansible...@googlegroups.com
What is this? A snippet from a playbook?
Because there is no task called 'database'.
Post your entire playbook.
--
You received this message because you are subscribed to the Google Groups "Ansible Project" group.
To unsubscribe from this group and stop receiving emails from it, send an email to ansible-proje...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/ansible-project/23d5d85e-f597-4a9e-9363-4d5d22fc49f4%40googlegroups.com.
Sent from a mobile device - please excuse the brevity, spelling and punctuation.
Reply all
Reply to author
Forward
0 new messages