RE: View Creation
- From: "SHEEHAN, JEREMY" <JEREMY.SHEEHAN@xxxxxxx>
- To: "toon@xxxxxxxxxxx" <toon@xxxxxxxxxxx>
- Date: Tue, 28 Oct 2008 16:54:27 -0400
Really? That simple, huh? I'll consider this solved once I get the
information from the user.
Jeremy
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of Toon Koppelaars
Sent: Tuesday, October 28, 2008 4:47 PM
To: SHEEHAN, JEREMY
Cc: oracle-l@xxxxxxxxxxxxx
Subject: Re: View Creation
She needs the select object privilege granted directly from the other schema to
her schema.
I.e. not via a role.
On Tue, Oct 28, 2008 at 9:30 PM, SHEEHAN, JEREMY
<JEREMY.SHEEHAN@xxxxxxx<mailto:JEREMY.SHEEHAN@xxxxxxx>> wrote:
I've got a question in View creation and I think it has to do with permissions
on the base tables.
I've got a user who is trying to create a view on another user's schema, but is
unable to. She can select on the tables with no problem, but when she goes to
create the view she gets an 'insufficient privileges' error. Does she need
select with admin option on the tables in question?
Thanks guru's!
Jeremy
--
+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-
Toon Koppelaars
RuleGen BV
+31-615907269
toon_at_rulegen_dot_com
www_dot_rulegen_dot_com
Author: "Applied Mathematics for Database Professionals"
Other related posts:
