saya mau koreksi sedikit, anda kurang pada sytax DDL-nya,, seharusnya GRANT CREATE SESSION TO AAA
saya setuju meng-grant privilege ketimbang meng-grant role karena itu memang lebih aman. pada versi-versi berikutnya oracle akan menghapus role connect, resource dan dba. role connect --> grants *create session*, *alter session*, *create synonym*, *create view*, *create database link*, *create table*, *create cluster* and *create sequence* to *connect* role resource --> grants create table, create cluster, create sequence, create trigger, create procedure, create type, create indextype , *create operator* to *resource* role dba --> semua privilege CMIIW -firman- 2007/1/30, eldien hasmanto <[EMAIL PROTECTED]>: > > > > sql> CREATE USER AAA IDENTIFIED BY YYY DEFAULT TABLESPACE example > TEMPORARY TABLESPACE temp; > > lalu > > sql> GRANT CREATE SESSION; > CMIIW, > > Eldin > > To: [EMAIL PROTECTED] <indo-oracle%40yahoogroups.comFrom>: > [EMAIL PROTECTED] <puji_astuti88%40yahoo.comDate>: Sat, 27 Jan > 2007 19:58:28 -0800Subject: [indo-oracle] User Di Oracle 10g > > AssalamualaikumTeman2 yang Smart SemuanyaMohon bantuannya, Gimana cara > buat 2 user pada oracle 10g.Login pertama saya sebagai "system" Dan saya > ingin login dengan nama yang lain. Gimana yeah masMohon > Bantuannya.ThxRegardsPuji---------------------------------Need Mail > bonding?Go to the Yahoo! Mail Q&A for great tips from Yahoo! Answers > users.[Non-text portions of this message have been removed] > > __________________________________________________________ > Get the new Windows Live Messenger! > http://get.live.com/messenger/overview > > [Non-text portions of this message have been removed] > > > -- Firman HM PT. Xsis Mitra Utama Graha BIP 7th Floor Jl. Jend. Gatot Subroto Kav.23 Jakarta 12930 - Indonesia Tel : +62-21-5210565 Hotline : +62-21-5210564 Fax : +62-21-5229777 [Non-text portions of this message have been removed]
