<div>
Just be aware with these approaches that if a new table is added to the SAPDEV schema privileges need to be granted on the new table to the user or role.
</div>


Just be aware with these approaches that if a new table is added to the SAPDEV schema privileges need to be granted on the new table to the user or role.

<div>
<div class="content wysiwyg-content">
Good day Oracle Experts: <br />
<br />
I have a Schema called SAPDEV which has about 2000 tables in it. <br />
<br />
I would like to create a new user called GMASTERS &nbsp;that has SELECT only on all the SAPDEV schema with connect privliges only. &nbsp;Can you give me a good example on how I would do this?<br />
<br />
Thank you for your time today
</div>
</div>


Good day Oracle Experts: 

I have a Schema called SAPDEV which has about 2000 tables in it. 

I would like to create a new user called GMASTERS  that has SELECT only on all the SAPDEV schema with connect privliges only.  Can you give me a good example on how I would do this?

Thank you for your time today

Creating New User to view specific 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.