Re: View Creation
- From: "Toon Koppelaars" <toon@xxxxxxxxxxx>
- To: JEREMY.SHEEHAN@xxxxxxx
- Date: Tue, 28 Oct 2008 21:47:03 +0100
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>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:
