Re: Object privileges question

>
> 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.

user john needs to set up a synonym so when he uses "emp" it resolves to sys.emp (you could also set up a public synonym).

However, you should never ever create application tables with the sys account. Received on Mon Sep 10 2001 - 15:25:03 CDT