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

Thread: select * from tab

  1. #1
    Join Date
    Oct 2003
    Posts
    9

    select * from tab

    What privilages do you need to allow a user to perform this select?

    GRANT what??? TO USER;
    Last edited by jhutchin; 10-24-2003 at 10:08 AM.

  2. #2
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    grant select on tab to user
    David Aldridge,
    "The Oracle Sponge"

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

    Oracle ACE

  3. #3
    Join Date
    Jan 2001
    Posts
    3,134
    Uhm, err.......hmmmmmmm

    How many guesses do we get?

    I'll go with TRUNCATE.



    MH
    I remember when this place was cool.

  4. #4
    Join Date
    Jan 2001
    Posts
    3,134
    Originally posted by slimdave
    grant *** on tab to user
    C'mon Dave, it's Friday, let's have some fun with this one!!

    MH
    I remember when this place was cool.

  5. #5
    Join Date
    Jan 2003
    Location
    Hull, UK
    Posts
    220
    Hi

    Grant connect, resource to USER

    HTH

    SS

  6. #6
    Join Date
    Oct 2003
    Posts
    9
    Originally posted by slimdave
    grant select on tab to user
    That makes sense...

    TAB is a view but the user does not seem to be able to see it.

    ORA-00942: table or view does not exist.

    Any offers...

  7. #7
    Join Date
    Jan 2002
    Location
    Up s**t creek
    Posts
    1,525
    Is the user prefixing the name of the owning schema in the select or has a synonym for the object been created in the users schema?

    e.g.

    SELECT * FROM owner.table_name
    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!

  8. #8
    Join Date
    Oct 2003
    Posts
    9
    No.

    But it does work for;

    select * from sys.tab;

  9. #9
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    Originally posted by Srinivas_Sharma
    Hi

    Grant connect, resource to USER

    HTH

    SS
    Don't like it -- RESOURCE is a role that is probably either too broad or too narrow in scope for a particular situation. I would define my own.
    David Aldridge,
    "The Oracle Sponge"

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

    Oracle ACE

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