rekan2x, terimakasih atas sarannya.
> coba deh: > > select * from all_users; > > > Salam, > > > --- On Fri, 3/13/09, Andes Febrian <[email protected]> wrote: > From: Andes Febrian <[email protected]> > Subject: Re: [indo-oracle] list user > To: [email protected] > Date: Friday, March 13, 2009, 1:57 PM > > > > > > > > > > > > > syntax select * from dba_users untuk melihat semua user yg ada > di database, > > bukan cuma yg punya privilege dba saja. klo OE dan scott di install, akan > > terlihat kok. coba aja liat satu2 mas. CMIIW. > > > > regards, > > andes > > > > 2009/3/13 andre <an...@andrehartawan .web.id> > > > >> kalo Select * from dba_users; user yang dapet role dba aja yang > >> tampil,kalao untuk semua user apa ya > >> > >> > >> > Kalo pake ini gmn: > >> > Select * from dba_users; > >> > -----Original Message----- > >> > From: "andre" <an...@andrehartawan .web.id <andre%40andreharta >> wan.web.id> > >> > > >> > > >> > Date: Fri, 13 Mar 2009 13:37:10 > >> > To: <indo-oracle@ yahoogroups. com <indo-oracle% 40yahoogroups. com>> > >> > Subject: [indo-oracle] list user > >> > > >> > > >> > para guru, > >> > > >> > baru belajar oracle nih, > >> > saya coba create user dengan syntax > >> > > >> > CREATE USER 'xxx' IDENTIFIED BY 'nnnnn' DEFAULT TABLESPACE abc > >> > > >> > apa ya syntax untuk melihat list user secara keseluruhan, > >> > mohon pencerahannya > >> > > >> > salam > >> > andre > >> > > >> > > >> > > >> > > >> > [Non-text portions of this message have been removed] > >> > > >> > > >> > >> > >> > > > > -- > > Cheers, > > ^_^ Andes ^_^ > > > > [Non-text portions of this message have been removed] > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > [Non-text portions of this message have been removed] > >
