Re: roles
- From: David Fitzjarrell <oratune@xxxxxxxxx>
- To: Andrew Kerber <andrew.kerber@xxxxxxxxx>
- Date: Fri, 9 Mar 2012 06:55:59 -0800 (PST)
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
Other related posts:
