IDS Forum

RE: 302: No GRANT option or illegal option

Posted By: Martin Graney
Date: Tuesday, 20 June 2017, at 12:28 p.m.

In Response To: Re: 302: No GRANT option or illegal option (Informix DBA)

Dave:

Quite right. Thank you. I should have elaborated more. Too busy trying
to do multiple things rather than getting one thing done right.

Cheers!

Best regards,
Martin M. Graney
Queues Enforth Development, Inc.
�
This electronic message contains information which may be privileged,
confidential, or otherwise protected from disclosure. The information
contained herein is intended for the addressee or recipient only. If you
are not the addressee, or not the intended recipient, any disclosure,
copying, distribution, or use of the contents of this message (including
any attachments) is prohibited. If you have received this electronic
message in error, please notify the sender immediately and destroy the
original message and all copies. (Queues Enforth Development, Inc.)

-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
Informix DBA
Sent: Tuesday, June 20, 2017 11:37 AM
To: ids@iiug.org
Subject: Re: 302: No GRANT option or illegal option [39400]

Hi Martin and Juan,

On Informix 11.70 You can grant insert on a view. If I remove the cast in
the view definition, you can grant insert on the view.

grant insert on v_mytab to public;

Permission granted.

Inserting Rows Through a View:

https://www.ibm.com/support/knowledgecenter/en/SSGU8G_11.70.0/com.ibm.sqls
.doc/ids_sqs_0864.htm

--Dave

On Tue, Jun 20, 2017 at 11:27 AM, Juan Francisco González Navarro <
jfrancisco.navarro@gmail.com> wrote:

> Hi
>
> You can't insert on a view, it's Just for reading data.
>
> Regards
>
> On Jun 20, 2017 17:24, "Martin Graney" <mgraney@qed.com> wrote:
>
> > You cannot GRANT INSERT on a view.
> >
> > -----Original Message-----
> > From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf
> > Of Informix DBA
> > Sent: Tuesday, June 20, 2017 10:25 AM
> > To: ids@iiug.org
> > Subject: 302: No GRANT option or illegal option [39397]
> >
> > Hi,
> >
> > We are running Informix 11.70.FC7W2 on Solaris. We create the table
> > and view below and are able to grant select, delete and update
> > permission to public. However we get the following error when trying
> > to grant insert permissions. The challenge is that the application
> > has an issue using the
> > lvarchar(1500) datatype so we created a view and tried casting that
> > to
> > char(1500) to "trick" the application. We are aware of another
> > workaround of using a header/detail table to allow messages of
> > unlimited length as was previously presented in this forum. Any
> > suggestions for this particular issue?
> >
> > create table mytab
> > (
> >
> > rec_key serial
> > ,message lvarchar(1500)
> > ) lock mode row;
> >
> > create view v_mytab (rec_key, message) as select rec_key,
> >
> > message::char(1500)
> >
> > from mytab;
> >
> > grant select, delete, update on v_mytab to public;
> >
> > Permission granted.
> >
> > grant insert on v_mytab to public;
> >
> > 302: No GRANT option or illegal option on multi-table view.
> > Error in line 1
> > Near character position 32
> >
> > Thank You,
> >
> > --Dave
> >
> > ************************************************************
> **************
> > *****
> > Forum Note: Use "Reply" to post a response in the discussion forum.
> >
> >
> > ************************************************************
> > *******************
> > Forum Note: Use "Reply" to post a response in the discussion forum.
> >
> >
>
>
> ************************************************************
> *******************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>

**************************************************************************
*****
Forum Note: Use "Reply" to post a response in the discussion forum.

Messages In This Thread

• 302: No GRANT option or illegal option
  Informix DBA -- Tuesday, 20 June 2017, at 10:25 a.m.
  • RE: 302: No GRANT option or illegal option
    Martin Graney -- Tuesday, 20 June 2017, at 11:23 a.m.
    • RE: 302: No GRANT option or illegal option
      Juan Francisco González Navarro -- Tuesday, 20 June 2017, at 11:27 a.m.
      • Re: 302: No GRANT option or illegal option
        Informix DBA -- Tuesday, 20 June 2017, at 11:37 a.m.
        • RE: 302: No GRANT option or illegal option
          Martin Graney -- Tuesday, 20 June 2017, at 12:28 p.m.
      • RE: 302: No GRANT option or illegal option
        Mike Walker -- Tuesday, 20 June 2017, at 11:42 a.m.
      • RE: 302: No GRANT option or illegal option
        Pierrot, Josue -- Tuesday, 20 June 2017, at 12:25 p.m.
    • RE: 302: No GRANT option or illegal option
      Pierrot, Josue -- Tuesday, 20 June 2017, at 12:31 p.m.
  • Re: 302: No GRANT option or illegal option
    BENJAMIN THOMPSON -- Wednesday, 21 June 2017, at 5:05 a.m.
    • Re: 302: No GRANT option or illegal option
      LUIS MARQUES -- Thursday, 22 June 2017, at 6:12 a.m.

IDS Forum is maintained by Administrator with WebBBS 5.12.