On Wed, 20 May 2020 at 22:51, jitendra kumar singh < [email protected]> wrote:
> 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: > > - database: testDB > grant_option: no > objs: ALL_IN_SCHEMA > state: present > privs: select > type: table > role: read_only_role > 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 [email protected]. > 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. -- 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 [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/ansible-project/CAL8fbwNWaupp2DQ08VaOrj-Z4rfaL7-L9q%3DV7qQUybbu_O%2BFig%40mail.gmail.com.
