Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Object privileges question
Dear all,
I am gladed to receive so many responses and helps.Thousands thanks for all of your useful recommendations. THANKS.
"Jordan" <mj_at_nba.com> ¼¶¼g©ó¶l¥ó news:9nijjq$se36_at_imsp212.netvigator.com...
> 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 Thu Sep 13 2001 - 10:19:12 CDT