tambahan sedikit.... role2 tersebut merupakan role2 yg ada pada Oracle 9iR2
CMIIW -firman- 2007/1/30, Firman H.M. <[EMAIL PROTECTED]>: > > 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 > -- 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]
