Results 1 to 5 of 5

Thread: permissions

  1. #1
    Join Date
    Feb 2002
    Location
    San Francisco, CA
    Posts
    441

    Unanswered: permissions

    I am trying to execute the following code; it works when connected as system, but not as a lower user. What priviages do I need to give the lower user?
    Code:
    SELECT JOB, SUBSTR(WHAT,1,35), NEXT_DATE, NEXT_SEC, INTERVAL FROM DBA_JOBS;
    (Btw: the code lists the current jobs)

    I have tried giving the lower user select any table priv. but it didn't work.

  2. #2
    Join Date
    Apr 2003
    Location
    NY
    Posts
    208

    Re: permissions

    DBA_XXX views are only accessible by DBA or system accounts. Users can see USER_XXX views. So you can query USER_JOBS and get any records back for the user.



    Originally posted by rhs98
    I am trying to execute the following code; it works when connected as system, but not as a lower user. What priviages do I need to give the lower user?
    Code:
    SELECT JOB, SUBSTR(WHAT,1,35), NEXT_DATE, NEXT_SEC, INTERVAL FROM DBA_JOBS;
    (Btw: the code lists the current jobs)

    I have tried giving the lower user select any table priv. but it didn't work.

  3. #3
    Join Date
    Apr 2003
    Location
    Greenville, SC (USA)
    Posts
    1,155

    Re: permissions

    I believe that all you need is to grant SELECT on dba_jobs
    from the SYS account. This is a view from sys.job$ table.



    I am trying to execute the following code; it works when connected as system, but not as a lower user. What priviages do I need to give the lower user?
    Code:
    SELECT JOB, SUBSTR(WHAT,1,35), NEXT_DATE, NEXT_SEC, INTERVAL FROM DBA_JOBS;
    (Btw: the code lists the current jobs)

    I have tried giving the lower user select any table priv. but it didn't work. [/SIZE][/QUOTE]

  4. #4
    Join Date
    Feb 2002
    Location
    San Francisco, CA
    Posts
    441

    Re: permissions

    Originally posted by carloa
    DBA_XXX views are only accessible by DBA or system accounts. Users can see USER_XXX views. So you can query USER_JOBS and get any records back for the user.


    just what i needed thanx!

  5. #5
    Join Date
    Apr 2003
    Location
    Minneapolis, MN
    Posts
    273
    Dear rhs98,

    You can assign SELECT_CATALOG_ROLE to that user.

    thanks,

    Hings.

    ======

    Still Learning...

Posting Permissions

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