Date: Fri, 9 Mar 2012 21:45:38 +0530
is your user able to connect to oracle can he create the session. create another role..assign the objects to that role along with proper grants and privs and assign this role to a user. if the objects are belonging to different schema then grants and privs has to be assign in different way..
thanks and take care..subodh
On 9 March 2012 00:37, Zelli, Brian <Brian.Zelli_at_roswellpark.org> wrote:
> It has been a while but I created a role, assigned objects to the role and
> then assigned the role to a user. The user is saying he can't select the
> objects I gave him select privs on. I forgot but am I missing anything
> This email message may contain legally privileged and/or confidential
> information. If you are not the intended recipient(s), or the employee or
> agent responsible for the delivery of this message to the intended
> recipient(s), you are hereby notified that any disclosure, copying,
> distribution, or use of this email message is prohibited. If you have
> received this message in error, please notify the sender immediately by
> e-mail and delete this email message from your computer. Thank you.
-- ============================================= Love me or Hate me both are in my Favour. Love me, I am in your Heart. Hate me, I am in your Mind. ============================================= -- http://www.freelists.org/webpage/oracle-lReceived on Fri Mar 09 2012 - 10:15:38 CST