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_at_pd7tw2no>
Date: Sat, 31 Jan 2004 05:14:31 GMT
Message-ID: <XQGSb.342618$X%5.28732_at_pd7tw2no>
tracy wrote:
> I not sure if i posted to the rite group, but hope somebody can help.
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)
>
> 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....
etc etc Received on Sat Jan 31 2004 - 06:14:31 CET