Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Sign In Apply for Membership

Tagged

Mailing list users (luciddb-users) can "claim" their threads in the archives by registering with the same account they used to post to the email list. NOTE: List threads are updated once every 24hrs.
Problems with the new applib.show_idx_candidates
  • nicow December 2011
    Hi all,

    today I tried to use the new applib feature and ran into an access rights problem.

    While executing the this Query:
    select * from table(applib.show_idx_candidates('LOCALDB', 'MY_SCHEMA', 'MY_TABLE', 80));

    i get an Error: org.eigenbase.applib.resource.ApplibException (state=,code=0)

    The Log-File shows:
    SEVERE: Privilege "SELECT" required for access to view "MGMT"."DBA_INDEX_COLUMNS_INTERNAL"

    I tried:
    CALL APPLIB.GRANT_SELECT_FOR_SCHEMA('MGMT', 'my-user');
    Error: DDL validation error near line 1, column 24: Reference to unknown table "REPOSITORY_PROPERTIES_VIEW" (state=,code=0

    GRANT SELECT ON "MGMT"."DBA_INDEX_COLUMNS_INTERNAL" TO "my-user";
    Error: DDL validation error near line 1, column 24: Reference to unknown table "DBA_INDEX_COLUMNS_INTERNAL" (state=,code=0)

    Any thoughts?

    Thanks
    Nicow