# How to provide select access to future objects

**URL:** <https://forum.ansible.com/t/how-to-provide-select-access-to-future-objects/32969>\
**Category:** Ansible Developer\
**Created:** [May 19, 2020, 11:23am UTC](https://forum.ansible.com/t/how-to-provide-select-access-to-future-objects/32969 "2020-05-19T11:23:59Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![Banti\_Kr](https://avatars.discourse-cdn.com/v4/letter/b/57b2e6/32.png) [@Banti\_Kr](https://forum.ansible.com/u/Banti_Kr)\
**Post date:** [May 19, 2020, 11:23am UTC](https://forum.ansible.com/t/how-to-provide-select-access-to-future-objects/32969/1 "2020-05-19T11:23:59Z")

</div>

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  
&nbsp;&nbsp;&nbsp;grant\_option: no  
&nbsp;&nbsp;&nbsp;objs: ALL\_IN\_SCHEMA  
&nbsp;&nbsp;&nbsp;state: present  
&nbsp;&nbsp;&nbsp;privs: select  
&nbsp;&nbsp;&nbsp;type: table