Dear : All
Can you tell me what other views i need to create to
ensure not other user can see my schema.
regards
JKean
- Tim Gorman <tim_at_sagelogix.com> wrote:
> 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).
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: Kean Jacinta
INET: jacintakean_at_yahoo.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).
Received on Thu Dec 11 2003 - 23:40:35 CST
