<div>
<div class="content wysiwyg-content">
I want a certain user to have SELECT privileges on all tables in a particular schema. &nbsp;If new tables are added to that schema I want to user to have SELECT privilege without having to issue a new GRANT SELECT for the new table. &nbsp;Is this possible?
</div>
</div>


I want a certain user to have SELECT privileges on all tables in a particular schema.  If new tables are added to that schema I want to user to have SELECT privilege without having to issue a new GRANT SELECT for the new table.  Is this possible?

Perennial Grant Select On Schema

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.