Results 1 to 5 of 5
  1. #1
    Join Date
    Jan 2003
    Location
    The Netherlands
    Posts
    149

    Smile Unanswered: select right on ctxsys view

    Hello when I execute the following procedure it gives a permission error:
    CREATE OR REPLACE PROCEDURE ISH."TEST" ()
    AS
    cVersion VARCHAR(10);
    BEGIN
    SELECT VER_CODE
    INTO cVersion
    FROM ctxsys.ctx_version
    WHERE ROWNUM = 1
    ;
    EXCEPTION
    WHEN NO_DATA_FOUND THEN
    NULL;
    END;
    /

    When i say:
    grant select on ctxsys.ctx_version to ish;
    Than it will work. But when I got the error I already did:
    GRANT SELECT ANY DICTIONARY TO ISH WITH ADMIN OPTION;
    Why was this not enough?
    How can I get all select-rights on ctxsys-views with only one grant-statement?

    thanks beforehand

    Coen Dunnink
    The Netherlands

  2. #2
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    SELECT ANY DICTIONARY allows you to query any data dictionary object in the SYS schema. CTXSYS is user different from SYS, so this privilege doesn't apply to CTXSYS user.

  3. #3
    Join Date
    Jan 2003
    Location
    The Netherlands
    Posts
    149

    all select right

    So how can I get all select-rights on ctxsys-views with only one grant-statement?

  4. #4
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    You can not. Privileges are to be granted one by one, for every table/view separately.

  5. #5
    Join Date
    May 2004
    Location
    Dominican Republic
    Posts
    721
    per your question, how about grant select any table to ish ?

    Of course, you know this will actually grant priviledge to the user not only to ctxsys tables, but for any user.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •