Re: Users & ownership

Hi,

If you've granted the privileges properly, then user1 can access the table of user2 PROVIDED you use the correct syntax;

You must qualify the table name with the owner's name like this (assume you're logged in as user1) :

SELECT * FROM USER2.EMP; The syntax has the owner's name (USER2) followed by a period, followed by the table name (EMP).

A common practice is to create a SYNONYM for user2.emp and grant privileges to that object so your syntax isn't so complicated...ie. give the synonym a more friendly name than 'user2.emp'...

I hope this helps,

Steve Received on Sun Jan 06 2002 - 08:00:28 CST