ERPstuff - Oracle EBS Community

Posted: **Thu Jul 23, 2009 2:19 pm**

Hi all.
How can we insert,update,select into another user tables without connect to the same user ?I tried to create roles but it did not work for me.Can anyone guide me plz?

Sarah

Posted: **Fri Jul 31, 2009 7:29 am**

[quote]Hi all.
How can we insert,update,select into another user tables without connect to the same user ?I tried to create roles but it did not work for me.Can anyone guide me plz?

Sarah

<i><div align="right">Originally posted by sarahaman

Posted: **Sat Aug 01, 2009 7:21 am**

thanks alot but i also created public synonym its working perfect but guide me about synonym its good idea or not that i created for each table?

sarah

ERPstuff - Oracle EBS Community

How can we create Roles ?

How can we create Roles ?