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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

How create multiple users for same schema

DBQuestApr 24 2008 — edited Apr 24 2008

Hi All,
I have a requirement that,
Three other systems connect to Our system database(lets say our system schema is ABC) and retrieve data from 3 tables and updates one table of schema ABC. so what i have to do is i need to create 3 different users and they should have select priviliges on only those 3 tables and update privilige on only that one table. How to implement this.
One more doubt is what is the difference between a schema & User?

Please give me solution for above requirement and clarify my above doubt.

Thanks
Santhosh N

Locked Post

New comments cannot be posted to this locked post.

Locked on May 22 2008

Added on Apr 24 2008

#general-database-discussions

7 comments

2,383 views