Re: User Security

From: Wayne Linton <lintonw_at_cadvision.com>
Date: 1997/07/17
Message-ID: <33CEDA05.58BE@cadvision.com>#1/1

Access to your own schema objects only is the default security in ORACLE. If you can see someone else's schema objects, then they have granted you permission to do so,
granted select to PUBLIC, or you have granted SELECT ANY TABLE privilege to your users.

Wayne Linton, I.S.P.
Shell Canada Ltd.

Brian Camper wrote:
>
> Forgive the "beginner material" in this question but I have looked
> everywhere and can not find an answer. I have different users on different
> projects, they are accessing different tablespaces but still can see each
> others tables. I would like the user just to be able to see the tables
> that he/she creates. How can I do this? Thank you in advance.
>
> Brian Camper
> brianc_at_cmhc.com
Received on Thu Jul 17 1997 - 00:00:00 CDT