Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Accessing other users' tables
Hi Erik,
Simply create public synonyms for those tables as user with DBA authority
(usually sys or system).
The syntax is
create public synonym table_name for sa.table_name;
of course you also will need to grant select privileges to either specific oracle users or the dummy user public. In terms of security probably not the best solution.
Hth,
Sybrand Bakker, Oracle DBA
Erik Forkalsrud wrote:
> Thanks to everyone that answered my previous question. Here
> is another easy question for you.
>
> I'm new to Oracle and I'm trying to migrate an application from
> MS SQL 6.5 to Oracle 8.
>
> I used the Oracle Migration Workbench to migrate the users/tables
> to Oracle. On SQL Server, the owner of the tables was called sa,
> and this is also the owner in Oracle.
>
> In the existing application code, all users access the tables using only
>
> the names, like SELECT * FROM table_name, but int the Orcale database
> i need to add the table owner: SELECT * from sa.table_name;
>
> Is there any way I can skip the owner part in from of each table
> reference, so I don't have to rewrite all the queries throughout the
> application?
>
> Erik Forkalsrud
>
> ______________________________________________
> Commission Junction - Partner With Us!
> Web: http://www.commission-junction.com
> Phone: 1.805.683.1522
Received on Sat Jan 16 1999 - 15:55:04 CST