GRANT on VIEW

[Marvin]

Hi !

I have created view to existing table from the user tmpuser1

> info access for mytable;
User Select Update Insert Delete
Index Alter
tmpuser1 All All Yes Yes
No No

Now, I want to add same access to tmpuser2, but I get following message.

> grant all on mytable to tmpuser2;
302: No GRANT option or illegal option on multi-table view.
Error in line 1
Near character position 29

Any Hint ?

Thanks
Alex

[Ben Draper]

Marvin,

I'm new to informix and tried this last week. It was on a multi-table view
and I received a similar error.
The issue seemed to be that only SELECT privileges are allowed on a
multi-table view and grant all is
trying to assign more "options" than allowed...

HTH,

Ben

Marvin wrote in message <38BB8E...@zag.si>...

[Jonathan Leffler]

Ben Draper wrote:

> I'm new to informix and tried this last week. It was on a multi-table view
> and I received a similar error.
> The issue seemed to be that only SELECT privileges are allowed on a
> multi-table view and grant all is
> trying to assign more "options" than allowed...

That's right. You can't do deletes, or inserts, or updates on
a multi-table view, so you can't grant those privileges either.
Similarly for indexing, altering and referencing.

Of course, C J Date would argue that you should be able to do
inserts, deletes and updates on many of multi-table views, but
that is a separate issue (I agree, and it would be nice, but...)

> Marvin wrote in message <38BB8E...@zag.si>...

> >I have created view to existing table from the user tmpuser1
> >
> >> info access for mytable;
> >User Select Update Insert Delete
> >Index Alter
> >tmpuser1 All All Yes Yes
> >No No
> >
> >Now, I want to add same access to tmpuser2, but I get following message.
> >
> >> grant all on mytable to tmpuser2;
> > 302: No GRANT option or illegal option on multi-table view.

--
Jonathan Leffler (jlef...@informix.com, jlef...@earthlink.net)
Guardian of DBD::Informix v0.95 -- see http://www.perl.com/CPAN
#include <disclaimer.h>

[Marvin]

Jonathan Leffler wrote:
>
> Ben Draper wrote:
>
> > I'm new to informix and tried this last week. It was on a multi-table view
> > and I received a similar error.
> > The issue seemed to be that only SELECT privileges are allowed on a
> > multi-table view and grant all is
> > trying to assign more "options" than allowed...
>
> That's right. You can't do deletes, or inserts, or updates on
> a multi-table view, so you can't grant those privileges either.
> Similarly for indexing, altering and referencing.
>
> Of course, C J Date would argue that you should be able to do
> inserts, deletes and updates on many of multi-table views, but
> that is a separate issue (I agree, and it would be nice, but...)
>

Hi !

Maybe I don't understand what multi-table means, but in my VIEW, I have
only one table with 6 fields. I don't think, If you create view under
one
username, the others can reach it. Perhaps I should grant view as a
public,
but I don't know how. My goal is getting information from that VIEW from
two different login names.

Regards
Alex

[Rudy Fernandes]

Who are you logged in as when you run into the error?

As "informix" or the owner of the view, you should be able to

grant all on <view> to public;

Rudy

[Marvin]

I get the same message:

> grant all on mytable to public;

302: No GRANT option or illegal option on multi-table view.

Error in line 1
Near character position 28

Alex

[Watawinona]

add an AS-clause, e.g.

GRANT SELECT TO 'xyz' AS 'abc'

Nona