Re: Managing Oracle Users
From: CarlosAL <miotromailcarlos_at_netscape.net>
Date: Fri, 31 Jul 2009 00:11:08 -0700 (PDT)
Message-ID: <bc1a9001-0a79-443b-931e-a4782052f1d3_at_w41g2000yqb.googlegroups.com>
On Jul 31, 7:16 am, undbund <undb..._at_gmail.com> wrote:
> Hi I had created a user with connect role and resorce role. When I
> login to Oracle with this user, I am still able to see other shemas
> and view their tables. Is there a way to prevent this so that when a
> user who is a non dba logins in he/she should not see other shemas and
> their tables and other objects?.
>
> Thanks,
> Undbund
Date: Fri, 31 Jul 2009 00:11:08 -0700 (PDT)
Message-ID: <bc1a9001-0a79-443b-931e-a4782052f1d3_at_w41g2000yqb.googlegroups.com>
On Jul 31, 7:16 am, undbund <undb..._at_gmail.com> wrote:
> Hi I had created a user with connect role and resorce role. When I
> login to Oracle with this user, I am still able to see other shemas
> and view their tables. Is there a way to prevent this so that when a
> user who is a non dba logins in he/she should not see other shemas and
> their tables and other objects?.
>
> Thanks,
> Undbund
REVOKE?
Not giving these roles?
Giving the -and only the- desired rights to users?
Cheers.
Carlos. Received on Fri Jul 31 2009 - 02:11:08 CDT