-
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|