Skip to Main Content
Forums

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to restrict user to certain tables

660227Sep 17 2008 — edited Sep 17 2008
Hi All

I have a third party application that I look after and we are needing to open up access to the Oracle 10g database to an outside company. What I would like to do is restrict their user so they can only select,insert,update on a couple of tables.

The main problem with this is that the way the database has been designed for the application is all the tables are owned by one user. All the tables have been granted ALL to public. So if I create a user in this DB then by default they have access to all the tables PUBLIC does !

I don't have many options as I can't change the structure as this would have serious impacts on the application so I have to work with what I've got.

Even with PUBLIC having access to all the tables is there still a way I can restrict a user to certain tables ?

Comments

Processing
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Oct 15 2008
Added on Sep 17 2008
#access, #general-database-discussions, #user
12 comments
949 views