Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Object privileges question

Re: Object privileges question

From: David Fitzjarrell <oratune_at_msn.com>
Date: 10 Sep 2001 12:56:39 -0700
Message-ID: <32d39fb1.0109101156.203a151b@posting.google.com>


Synonyms are what you are looking for.

Connected as john type the following:

create synonym emp for sys.emp;

This will let john type 'select * from emp;' instead of 'select * from sys.emp;'.

David Fitzjarrell
Oracle Certified DBA

"Jordan" <mj_at_nba.com> wrote in message 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 Mon Sep 10 2001 - 14:56:39 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US