Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> 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