Re: Hide schema from other user.

Sure! Create the following views while connected as schema A:

   create view dba_users
   as
   select * from sys.dba_users
   where username not in ('C','D');

   create view all_users
   as
   select * from sys.all_users
   where username not in ('C','D');

You might need to have SYS grant you explicit SELECT permissions on these views -- usually they are granted through a role, which is insufficient for creating compiled objects like views and procedures.

You might also have to create similar views named DBA/ALL_OBJECTS, DBA/ALL_SEGMENTS, DBA/ALL_TABLES, etc in order to make the deception complete...

on 12/10/03 7:49 PM, Kean Jacinta at jacintakean_at_yahoo.com wrote:

> Hello : All
>
> I have a scenario here. I have a database name :
> CYBER.
> I am using oem to manage this dbase.In this database ,
> i have created 4 schema . which is schema A, schema B,
> schema C and schema D.
>
> When i login into the dbase using schema A user id
> throught oem , i can see all other 3 schema B,C and D.
> I need the system to only show schema A and B while
> schema C and D will be hidden .
>
> Can anyone tell me how can i achieved this ? or maybe
> this can't be done. I am not sure. pls guide me .
>
> Thank in advanced
>
> regards
> JKean
>
>
>
>
>
> __________________________________
> Do you Yahoo!?
> New Yahoo! Photos - easier uploading and sharing.
> http://photos.yahoo.com/

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Tim Gorman
  INET: tim_at_sagelogix.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).