IDS Forum

RE: 302: No GRANT option or illegal option

Posted By: Pierrot, Josue
Date: Tuesday, 20 June 2017, at 12:25 p.m.

In Response To: RE: 302: No GRANT option or illegal option (Juan Francisco González Navarro)

Probably try granting it as the owner of the underlying table. See what you get.

grant insert on v_mytab to public as " owner".

Josue Pierrot
Database Administrator, Information Technology

82 Hopmeadow St, Simsbury, US
O 8604082129 M 8609214920 F 8604082139
E jpierrot@chubb.com

ACE and Chubb are now one.

-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Juan Francisco González Navarro
Sent: Tuesday, June 20, 2017 11:27 AM
To: ids@iiug.org
Subject: RE: 302: No GRANT option or illegal option [39399]

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.

____________________________________________________________________
This email (including any attachments) is intended for the designated recipient(s) only, and may be confidential, non-public, proprietary, and/or protected by the attorney-client or other privilege. Unauthorized reading, distribution, copying or other use of this communication is prohibited and may be unlawful. Receipt by anyone other than the intended recipient(s) should not be deemed a waiver of any privilege or protection. If you are not the intended recipient or if you believe that you have received this email in error, please notify the sender immediately and delete all copies from your computer system without reading, saving, printing, forwarding or using it in any manner. Although it has been checked for viruses and other malicious software ("malware"), we do not warrant, represent or guarantee in any way that this communication is free of malware or potentially damaging defects. All liability for any actual or alleged loss, damage, or injury arising out of or resulting in any way from the receipt, opening or use of this email is expressly disclaimed.
_____________________________________________________________________

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.