Database Administration (MOSC)

MOSC Banner

How to access objects without using "." operator

edited Mar 31, 2013 8:00PM in Database Administration (MOSC) 2 commentsAnswered
Hello  All,

 

May I know the steps to access the objects owned by other user without using “.” Operator for example

I have two users “TESTUSER” and “USERACCESS”  the TESTUSER owns tables EMP,DEPT..

is there a way to “USERACCESS” can access the EMP/DEPT tables without using the ” .” like  select * from emp; (not as select * from TESTUSER.EMP);

Thanks

Sankar

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center