I agree; the original post complained of grants througn a role not being available thus my response. This issue can have a couple of causes depending upon what error is received and during what operations it is displayed. A procedure that won't compile is due to missing direct grants on the table or tables; 'table or view doe snot exist' errors from SQL*Plus can be grant or synonym issues. The problem has not been well defined; I probably shouldn't have jumped on the bandwagon before the issue was described in more detail. David Fitzjarrell ________________________________ From: Andrew Kerber <andrew.kerber@xxxxxxxxx> To: oratune@xxxxxxxxx Cc: "Brian.Zelli@xxxxxxxxxxxxxxx" <Brian.Zelli@xxxxxxxxxxxxxxx>; "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx> Sent: Thursday, March 8, 2012 6:45 PM Subject: Re: roles Most often when I have seen this happen the user had expected synonyms to be in place. On Thu, Mar 8, 2012 at 5:21 PM, David Fitzjarrell <oratune@xxxxxxxxx> wrote: Did you make the role the default for that user? > >David Fitzjarrell > > > >________________________________ > >From: "Zelli, Brian" <Brian.Zelli@xxxxxxxxxxxxxxx> >To: "'oracle-l@xxxxxxxxxxxxx'" <oracle-l@xxxxxxxxxxxxx> >Sent: Thursday, March 8, 2012 12:07 PM >Subject: roles > > >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 else? > >ciao, >Brian > > > >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. >-- >//www.freelists.org/webpage/oracle-l > >-- >//www.freelists.org/webpage/oracle-l > > > -- Andrew W. Kerber 'If at first you dont succeed, dont take up skydiving.' -- //www.freelists.org/webpage/oracle-l