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

Thread: privillege question

  1. #1
    Join Date
    Oct 2003
    Posts
    27

    privillege question

    the DBA grant some privillege to a new user. The new user can log on to SQL plus but not the OEM. The new user can select from ALL_OBJECTS and see the table names, but when he used the command DESC tablename, it returned with the message that the object did not exist. What is the problem?

  2. #2
    Join Date
    Apr 2003
    Location
    South Carolina
    Posts
    148
    desc owner.tablename

    HTH
    Gregg

  3. #3
    Join Date
    Oct 2003
    Posts
    27
    then, why the user can log on to SQL PLUS but not OEM?

  4. #4
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    Originally posted by jack999
    then, why the user can log on to SQL PLUS but not OEM?
    provide the error code

    you have to do desc schema.object_name

  5. #5
    Join Date
    Oct 2003
    Posts
    27
    Originally posted by pando
    provide the error code

    you have to do desc schema.object_name
    The error says insufficient privillege.

  6. #6
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    The problem is he has insufficient privs...
    Jeff Hunter

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