Topic
  • 5 replies
  • Latest Post - ‏2012-07-11T06:32:52Z by SystemAdmin
SystemAdmin
SystemAdmin
5837 Posts

Pinned topic Sample CREATE VIEW with WITH OPTIONS READ ONLY

‏2012-06-29T12:52:41Z |
Hi,
i will try to create a new view with "WITH OPTIONS READ ONLY" but i dont do.

someone would have any examples
simple to post with this feature read-only?

I wanted some example with all the read-only view as well.

Thanks.
Cláudio.
Updated on 2012-07-11T06:32:52Z at 2012-07-11T06:32:52Z by SystemAdmin
  • SystemAdmin
    SystemAdmin
    5837 Posts

    Re: Sample CREATE VIEW with WITH OPTIONS READ ONLY

    ‏2012-07-08T14:34:57Z  
    Hello Claudio,

    Can you tell us the exact CREATE VIEW statement you try in the SAMPLE database ?
    Regards
    Yves-Antoine Emmanuelli
  • SystemAdmin
    SystemAdmin
    5837 Posts

    Re: Sample CREATE VIEW with WITH OPTIONS READ ONLY

    ‏2012-07-09T10:38:38Z  
    Hello Claudio,

    Can you tell us the exact CREATE VIEW statement you try in the SAMPLE database ?
    Regards
    Yves-Antoine Emmanuelli
    CREATE VIEW CLIVEN ( CODIGO, NOME, "Vendedor" ) AS select a.codigo,a.nome,b.nome as "Vendedor" from cli a, ven b where a.codigo_ven = b.codigo;
  • SystemAdmin
    SystemAdmin
    5837 Posts

    Re: Sample CREATE VIEW with WITH OPTIONS READ ONLY

    ‏2012-07-09T20:46:09Z  
    CREATE VIEW CLIVEN ( CODIGO, NOME, "Vendedor" ) AS select a.codigo,a.nome,b.nome as "Vendedor" from cli a, ven b where a.codigo_ven = b.codigo;
    Hello Claudio,

    How about adding necessary REVOKE/GRANT statements to make this view READ ONLY ?
    Regards
    Yves-Antoine Emmanuelli
  • SystemAdmin
    SystemAdmin
    5837 Posts

    Re: Sample CREATE VIEW with WITH OPTIONS READ ONLY

    ‏2012-07-10T10:32:48Z  
    Hello Claudio,

    How about adding necessary REVOKE/GRANT statements to make this view READ ONLY ?
    Regards
    Yves-Antoine Emmanuelli
    only because I can do revoke grant read-only?

    'with options read only' used for?
  • SystemAdmin
    SystemAdmin
    5837 Posts

    Re: Sample CREATE VIEW with WITH OPTIONS READ ONLY

    ‏2012-07-11T06:32:52Z  
    only because I can do revoke grant read-only?

    'with options read only' used for?
    Hello Claudio,

    According to the reference documentation, this option is only relevant when you create a typed view (object oriented SQL) :

    http://pic.dhe.ibm.com/infocenter/db2luw/v10r1/index.jsp?topic=%2Fcom.ibm.db2.luw.sql.ref.doc%2Fdoc%2Fr0000935.html

    Regards
    Yves-Antoine Emmanuelli