synonyms or grant select access
692864Apr 10 2009 — edited Aug 12 2010hi 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?