Re: Newbie question on user rights
From: gazzag <gareth_at_jamms.org>
Date: Thu, 19 Nov 2009 06:30:20 -0800 (PST)
Message-ID: <1ef80410-fb4b-4421-a11d-d3846b7d8614_at_j24g2000yqa.googlegroups.com>
On 19 Nov, 14:24, gpadu99 <gpad..._at_gmail.com> wrote:
> A user corresponds to a schema. I am working on a database in which
> something strange happens: A user, can select or update records in
> another schema. How can I be sure that, no user other than the one
> with same name (as the schema name), can sonnect to that schema?
>
> Thanks very much for answering this newbie question..
Date: Thu, 19 Nov 2009 06:30:20 -0800 (PST)
Message-ID: <1ef80410-fb4b-4421-a11d-d3846b7d8614_at_j24g2000yqa.googlegroups.com>
On 19 Nov, 14:24, gpadu99 <gpad..._at_gmail.com> wrote:
> A user corresponds to a schema. I am working on a database in which
> something strange happens: A user, can select or update records in
> another schema. How can I be sure that, no user other than the one
> with same name (as the schema name), can sonnect to that schema?
>
> Thanks very much for answering this newbie question..
You will find that the user has been granted SELECT and UPDATE privileges to objects in the other schema - this is not by default. You (the DBA) will have to revoke these rights if this is not what you want.
Look in the Oracle documentation for the GRANT and REVOKE commands. The data dictionary view DBA_TAB_PRIVS is a view that will provide you with the relevant information.
HTH -g Received on Thu Nov 19 2009 - 08:30:20 CST