How can we create Roles ?

To discuss Oracle Forms & Reports related technical issues.
Post Reply
sarahaman
Posts: 7
Joined: Fri Jul 17, 2009 4:58 pm
Location: Qatar

How can we create Roles ?

Post by sarahaman »

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
Kashif
Posts: 137
Joined: Wed Apr 26, 2006 5:57 am
Location: Pakistan
Contact:

Post by Kashif »

[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
sarahaman
Posts: 7
Joined: Fri Jul 17, 2009 4:58 pm
Location: Qatar

Post by sarahaman »

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
Post Reply

Who is online

Users browsing this forum: No registered users and 1 guest