Menu ▾ ▴

#14 No create synonym and materialized view privileges

2.9.0.2
wont-fix
Jari Laine
apex (1)
general commen
reader app
2015-02-14
2015-02-14
Leckraj Deeljore
No

Hi, I am on Oracle cloud with an APEX single schema subscription without the
create synonym and materialized view privileges.

Can I do anything to get the applications working?

Thanks
leckraj

Discussion

  • Jari Laine

    Jari Laine - 2015-02-14

    Hi,

    Of course you can modify application to work without those privileges.
    But if you modify application, then upgrade to next version will not work. Also I can't support modified application.

    It might be easier ask from hosting company to grant those privileges to your schema.
    Those are recommended privileges for application parsing schema in APEX documentation.
    https://docs.oracle.com/cd/E37097_01/doc.42/e35125/priv_db_user.htm#HTMDB28636

    Regards,
    Jari

     

    Last edit: Jari Laine 2015-02-14

  • Jari Laine

    Jari Laine - 2015-02-14
    • status: open --> wont-fix
     

  • Leckraj Deeljore

    Leckraj Deeljore - 2015-02-14

    Hi Jari,

    I'll try to work around these privileges then.Thats a lot of code in the installation script,needed a lot of work. Did you expand on the old packaged forum application that stopped at version 0.92 for some reason or did you rewrite everything?

    Regards
    Leckraj

     

    • Jari Laine

      Jari Laine - 2015-02-19

      Hi,

      For first version I did use Ask Expert packaged application.

      Then I did rewrite everything.

      Regards,
      Jari

       

  • Leckraj Deeljore

    Leckraj Deeljore - 2015-02-14

    Seems OK after a few changes here and there. Thanks.