Re: sharing same tablespace , can't see table of other user?

Hi Eugene,

it is ORACLE's expected behaviour. Only the owner of a table has access to it until he decides to grant privileges to other users. So if you want user2
to be able to select data from a table 'test' owned by user1 you have to issue a command (connected as user1) like: GRANT select ON test TO user1.

And keep in mind that user2 has to qualify the tablename with the schema when
trying to access it:
SELECT * FROM user2.test.

This can be avoided by generating a synonym.

hth,
Guido Received on Fri Sep 06 2002 - 01:12:42 CDT