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]
