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

Thread: what privillege to grant?

  1. #1
    Join Date
    Oct 2003
    Posts
    27

    what privillege to grant?

    we have a new employee who is a data modeler. He needs to see the stuctures of all the existing tables. As a DBA, how do you grant privile to him?

  2. #2
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    "create session" and "select any dictionary" should do it.
    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE

  3. #3
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    select any table you mean

  4. #4
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    only if he needs to see the data -- if it's just the structures then the dictionary priv should suffice.
    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE

  5. #5
    Join Date
    Jul 2000
    Posts
    521
    "select any" (table or dictionary) will make the user see dba tables/views as well. Not a big problem but then you always come across users fresh out of a 3-day class and they ask you questions like "why is SQL*Net message received" waits are too high ??
    svk

Posting Permissions

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


Click Here to Expand Forum to Full Width