Re: newbie - table access questions

Not security.
Oracle implement the three schema architecture devised in the seventies. You have a logical a conceptual and a physcial schema. Your user2 is a physical schema and your user1 is too. Hence you need either to prefix your table with the owner of the table, or create a private or public synonym for that table. Create [public] synonym <synonym> for <owner>.<table>

Hth,

Sybrand Bakker, Oracle DBA

"Bernard Lin" <bernie_at_beyondbond.com> wrote in message news:uQ465.103$sa3.2448_at_news.nyc.globix.net...
> Hi, I'm new to Oracle.
>
> I create two users. "user1", and "user2".
>
> I created a table from user1's account.
> I granted select and update on the table to user2.
>
> When I login as user2, I cannot see the table that was created.
> It seems like there another layer of security separation that I don't know
> about. Any ideas?
>
> --
> Bernard Lin
>
>
>
Received on Tue Jun 27 2000 - 00:00:00 CDT