Re: Managing Oracle Users

From: Gerard H. Pille <>
Date: Fri, 31 Jul 2009 11:47:37 +0200
Message-ID: <4a72bdb9$0$2855$>

undbund schreef:
> 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

Don't grant privileges on those objects to public, then your new user won't be able to see them. Received on Fri Jul 31 2009 - 04:47:37 CDT

Original text of this message