Hi,
I am using ansible to provide read/select access to user and it is working with below ansible code but the user is not able to access or run select to future objects means they can't access the tables created after user creation.How to use alter default privilege here with below code. This is what I am using:
- database: testDB
grant_option: no
objs: ALL_IN_SCHEMA
state: present
privs: select
type: table