DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: DBA privledges

  1. 02-28-2003, 06:41 AM #1
    Chucks_k
    Chucks_k is offline Senior Member
    Join Date
    Dec 2001
    Posts
    337

    DBA privledges

    Hello all,

    I need to create a user who can select from the dba_ and v$ views. The user also needs to execute some packages. However i do not want to give the user dba privledges. Is there an alternate way of doing this.

    Thanks.
    Chucks_k
    Reply With Quote Reply With Quote
  2. 02-28-2003, 06:44 AM #2
    adewri's Avatar
    adewri
    adewri is offline Oracle Monk
    Join Date
    Nov 2002
    Location
    New Delhi, INDIA
    Posts
    1,796
    grant select_catalog_role to user_name;

    for execute you need to give execute priv... to user
    Last edited by adewri; 02-28-2003 at 06:48 AM.
    Amar
    "There is a difference between knowing the path and walking the path."

    Amar's Blog  Get Firefox!
    Reply With Quote Reply With Quote
  3. 02-28-2003, 06:46 AM #3
    jovery's Avatar
    jovery
    jovery is offline Ha Ha
    Join Date
    Jan 2002
    Location
    Up s**t creek
    Posts
    1,525
    8i - SELECT_CATALOG_ROLE

    9i - SELECT ANY DICTIONARY

    Regards
    Jim
    Oracle Certified Professional
    "Build your reputation by helping other people build theirs."

    "Sarcasm may be the lowest form of wit but its still funny"

    Click HERE to vist my website!
    Reply With Quote Reply With Quote
  4. 02-28-2003, 07:04 AM #4
    Chucks_k
    Chucks_k is offline Senior Member
    Join Date
    Dec 2001
    Posts
    337
    Thanks all.

    That helps.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules

Click Here to Expand Forum to Full Width