Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback, please email oracle-forums_moderators_us@oracle.com

Hello I want to restrict my users to only see parts of the database they should, how?

3027807Sep 14 2015 — edited Sep 15 2015

Hi,

I am trying to restrict access to my database so the users can only see what they should only see.

For example, user Andrew should only be able to see students with a teacherid of 1 and a schoolid of 2. Where user Billy should only be able to access students with a teacherid of 3 and a schoolid of 4. User Charlie should only be able to access all students with a schoolid of 5.

At the moment, all users can access everything and I need to restrict these users access.

Can anyone help me with these and provide any solutions?

Thanks,

Rory

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 13 2015
Added on Sep 14 2015
8 comments
825 views