Object privileges question

Dear all,

            I have used "sys" account to create a table, called "emp". However, when one of the user called "john" want to select data from that table, messages "ORA-04043: object emp does not exist". I have already granted ALL rights to john, it doesn't work. But, when john type "select * from sys.emp;", it works. I want that john need not to type the owner in front of the table when each time he wants to access other tables. How can I do so? THANKS.

Best Regards,
Jordan Received on Mon Sep 10 2001 - 09:48:50 CDT