IDS Forum

RE: 302: No GRANT option or illegal option

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

In Response To: RE: 302: No GRANT option or illegal option (Martin Graney)

You are right.... I believe IT is possible on a single table view.... on a multi tables view I think THAT FEATURE is available on IDS12. Please validate!

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 Martin Graney
Sent: Tuesday, June 20, 2017 11:24 AM
To: ids@iiug.org
Subject: RE: 302: No GRANT option or illegal option [39398]

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.

____________________________________________________________________
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.