Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Object privileges question
In article <9nijjq$se36_at_imsp212.netvigator.com>, "Jordan" says...
>
>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
>
>
first DON'T USE SYS. Just stop doing that. Use anything other then SYS.
second, you can either:
o create a public synonym EMP for X.emp o create a private synonym in john's schema for X.emp o issue alter session set current_schema = X in johns session o create a view emp as select * from X.emp in john's schema
-- Thomas Kyte (tkyte@us.oracle.com) http://asktom.oracle.com/ Expert one on one Oracle, programming techniques and solutions for Oracle. http://www.amazon.com/exec/obidos/ASIN/1861004826/ Opinions are mine and do not necessarily reflect those of Oracle CorpReceived on Mon Sep 10 2001 - 10:41:33 CDT