Thank you for very fast response! Yes, SELECT ANY TABLE should be enough, but unfortunately is not, it works only with strict grant to mat. view.
I see them them when I query "SELECT * FROM SYS.all_mviews" or "SELECT * FROM SYS.all_objects where object_type = 'MATERIALIZED VIEW'". It was strange to me that you are using ALL_MVIEW_COMMENTS instead of ALL_MVIEWS. Is there any special reason for that? Version is Oracle Database 12c Standard Edition 12.2.0.1.0 64bit Production. Thanks On Thursday, November 14, 2019 at 1:37:49 PM UTC+1, Lukas Eder wrote: > > Hi Zoran, > > Thank you very much for your message. To my understanding, SELECT ANY > TABLE should be sufficient to see all materialised views from a given > schema, according to the documentation: > > https://docs.oracle.com/en/database/oracle/oracle-database/18/sqlrf/GRANT.html#GUID-20B4E2C0-A7F8-4BC8-A5E8-BE61BDC41AC3 > > > Could there be a bug in your Oracle version that prevents materialised > views from being listed in ALL_MVIEW_COMMENTS, in that case? Can you see > them in ALL_MVIEWS or ALL_OBJECTS? What Oracle version are you using? > > Thanks, > Lukas > > On Thu, Nov 14, 2019 at 1:30 PM Zoran <[email protected] <javascript:>> > wrote: > >> Hello Lukas, >> >> our client wants to create one database user on Oracle with as few grant >> possible for generating Java code. Tables, sequences, views are working >> fine but most materialized views are missing. >> >> As I understood from source code, you are pulling catalog from >> SYS.ALL_MVIEW_COMMENTS. All materialized views have comments on them. >> >> Current grants for that user : >> >> CREATE SESSION >> SELECT ANY TABLE >> SELECT ANY SEQUENCE >> EXECUTE ANY PROCEDURE >> >> If we grant SELECT ON SCHEMA.TABLE to this user, materialized view is >> picked up. However, that is not acceptable solution. Why SELECT ANY TABLE >> grant doesn't work? >> >> Any ideas? >> Thanks in advance. >> >> -- >> You received this message because you are subscribed to the Google Groups >> "jOOQ User Group" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to [email protected] <javascript:>. >> To view this discussion on the web visit >> https://groups.google.com/d/msgid/jooq-user/dc246d1b-4719-4679-9950-06d04886d8c9%40googlegroups.com >> >> <https://groups.google.com/d/msgid/jooq-user/dc246d1b-4719-4679-9950-06d04886d8c9%40googlegroups.com?utm_medium=email&utm_source=footer> >> . >> > -- You received this message because you are subscribed to the Google Groups "jOOQ User Group" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/jooq-user/fd91dfae-d3bb-4584-9351-92db51483052%40googlegroups.com.
