Re: Managing Oracle Users

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



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