Re: I needhelp

From: Bricklen <Xbricklen_at_yahoo.comX>
Date: Sat, 31 Jan 2004 05:14:31 GMT
Message-ID: <XQGSb.342618$X%5.28732@pd7tw2no>

tracy wrote:

> I not sure if i posted to the rite group, but hope somebody can help.
>
> as i know, system is the superpower user in oracle database. He can
> views everything, including role created by others DBA.
>
> My problem is when i connect as oracle, i unable to view roles created
> by dba_01. unless i conncet as dba_01.
>
> Can somebody tell me , what's wrong?
>
>
> thanq!!

SYS is the Supreme Being....

Try prefixing your queries for dba_01's objects with that username: eg. select * from dba_01.table_name;

(or grant dba privs etc to oracle user --> generally not a good idea)

etc etc Received on Fri Jan 30 2004 - 23:14:31 CST