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]. To view this discussion on the web visit https://groups.google.com/d/msgid/jooq-user/dc246d1b-4719-4679-9950-06d04886d8c9%40googlegroups.com.
