Skip to Main Content

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!

synonyms or grant select access

692864Apr 10 2009 — edited Aug 12 2010
hi i have a database with 2 user_login

1) owner login
2) user login

3)all tables that are created in the database will have the owner as ( owner login username)

4)user will be able to insert,delete,update,execute the objects of the owner




Now my question is ..... I have created all the tables through oWNER LOGIN

how do i make sure the point no. 4 is satisfied............?

my dba says to create synonyms etc which i did not understand.............. he can directly give ins,upd,select,exec privileges to those objects for the user right?


why is he asking me to create the synonyms....and whr should i create synonyms?
This post has been answered by 677340 on Apr 10 2009
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 9 2010
Added on Apr 10 2009
17 comments
25,464 views