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 [EMAIL PROTECTED] 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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
