Thanks Pak Herman, sudah saya coba, ternyata perintah Pak Herman belum bisa melakukan login, tadi saya baru dapat klo si "dayat" harus:
ALTER USER DAYAT DEFAULT TABLESPACE USERS ALTER USER DAYAT TEMPORARY TABLESPACE TEMP ALTER USER DAYAT QUOTA UNLIMITED ON USERS 2008/9/9 Herman B. Subroto <[EMAIL PROTECTED]> > Harus ditambahi dengan privileges connect dan resource, dari SYS or > SYSTEM execute command berikut: > > grant connect, resource to dayat; > > Hope This Help > -HBS > > > --- In [email protected] <indo-oracle%40yahoogroups.com>, dayat > <[EMAIL PROTECTED]> wrote: > > > > Para master oracle, > > > > Saya pemula oracle, sedang coba-coba belajar. Saya sudah buat > user "dayat" > > dengan menggunakan sys/as sysdba: > > > > CREATE USER dayat IDENTIFIED BY TEST; > > > > trus sewaktu login sebagai dayat dengan: > > > > CONNECT dayat/as sysoper > > > > ORA-01031: insuffient privileges > > > > nah, itu kenapa ya. > > > > saya pakai oracle 10g xe > > > > thanks > > dayat > > > > > > [Non-text portions of this message have been removed] > > > > > [Non-text portions of this message have been removed]
