Beranda > Oracle > Buat User di Oracle

Buat User di Oracle

Dijalankan di user system dan pws manager

CREATE TABLESPACE “username”
LOGGING
DATAFILE ‘C:\ORACLE\ORADATA\CNSPR\username.ora’ SIZE 100M
AUTOEXTEND
ON NEXT  10M MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL

CREATE USER “username”  PROFILE “DEFAULT”
IDENTIFIED BY “password” DEFAULT TABLESPACE “username”
TEMPORARY TABLESPACE “TEMP”
QUOTA UNLIMITED
ON username
ACCOUNT UNLOCK;
GRANT CREATE PROCEDURE TO “username”;
GRANT CREATE TABLE TO “username”;
GRANT CREATE VIEW TO “username”;
GRANT GRANT ANY PRIVILEGE TO “username”;
GRANT QUERY REWRITE TO “username”;
GRANT SELECT ANY TABLE TO “username”;
GRANT “CONNECT” TO “username”;
grant select any table,insert any table,delete any table,update any table to username;

Kategori:Oracle
  1. Belum ada komentar.
  1. No trackbacks yet.

Tinggalkan Balasan

Isikan data di bawah atau klik salah satu ikon untuk log in:

Logo WordPress.com

You are commenting using your WordPress.com account. Logout / Ubah )

Gambar Twitter

You are commenting using your Twitter account. Logout / Ubah )

Foto Facebook

You are commenting using your Facebook account. Logout / Ubah )

Foto Google+

You are commenting using your Google+ account. Logout / Ubah )

Connecting to %s

%d blogger menyukai ini: