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

Thread: SCHEMA TABLES TAB ACCESSIBILITY!!

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

    Query:

    1.Is it possible or is there any way privilege to access the following:

    Say from X's login,I pass the following query as under to access the tables of BALAJI's Schema where all the 300+ tables are stored:

    From X's Login:

    SELECT * FROM BALAJI.TAB;

    Thanks & Regards,

    Amit.





  2. #2
    Join Date
    Feb 2001
    Location
    Paris, France
    Posts
    809
    connect balaji/password
    grant select, insert,update, delete on tab to X;
    connect X
    select * from balaji.tab;

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