Re: View on a table of another user

Hello

I think that the problem is that the privileges necessary are granted through roles.
To create a view, its owner has to have privileges over the referenced table directly to him, not through a role.

So, this does not work:
  grant select on a.table1 to role1;
  grant role1 to b;
  create view b.v1 as select * from a.table1;

But this should work:
  grant select on a.table1 to b;
  create view b.v1 as select * from a.table1;

In article <8goea6$d2m$11$1_at_news.t-online.com>,   "Nicolas Bronke" <newsgroup_at_trinity.de> wrote:
> How can I create a view on table(owner is another user). Although I
 have
> allrights granted it looks as to be impossible.
>
> e.g. User1 wants to create
>
> create view user1.viewname as select * from user2.tablename
>
> Any suggestions?
>
> Regards
>
> Nicolas
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Mon May 29 2000 - 00:00:00 CDT