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

Thread: Problem with select * from schema.tab accessibility!!!

  1. #1
    Join Date
    Feb 2001
    Posts
    286
    Hi all!

    Working on Oracle v8i with OS as NT!

    I have this problem while creating the following as under:

    From Balaji login,I had granted the following privileges to user amitst as under:

    SQL> grant select,insert,update,delete on tab to amitst;

    Grant succeeded.

    Say for instance,I from my login(amitst) would like to view all the tables of BALAJI as under:

    SQL> conn amitst/amitst@biac
    Connected.
    SQL> select * from balaji.tab;
    select * from balaji.tab
    *
    ERROR at line 1:
    ORA-00942: table or view does not exist


    SQL>

    First of all,is the above procedure possible in Oracle!

    Why is the above command not accepted successfully!

    Could you please focus upon the area as to where I had gone wrong!

    Thanks & Regards,

    Amit.


  2. #2
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758
    TAB is not a TABLE but is a dictionary VIEW owned by sys. And the definition of that view is
    Code:
    select o.name, decode(o.type#,2, 'TABLE',3, 'CLUSTER',4, 'VIEW', 5, 'SYNONYM'), t.tab#
    from  sys.tab$ t, sys.obj$ o  
    where o.owner# = userenv('SCHEMAID')  
      and o.type# >=2
      and o.type# <=5
      and o.linkname is null
      and o.obj# = t.obj# (+)
    Sanjay

  3. #3
    Join Date
    Jan 2001
    Posts
    3,134
    Assuming that "tab" is your abbreviation for table_name i would suggest this.
    Verify yourself in SQL with the SHOW USER command.
    Make sure you are logged in with the right ID each time.
    Also make sure you are in the correct instance.

    MH
    I remember when this place was cool.

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