1 / 10

BEKERJA DENGAN COMMAND LINE

BEKERJA DENGAN COMMAND LINE. MEMBUAT USER. Masuk ke sql command line, start menu -> all program -> oracle -> Run sql command Login sebagai SYSTEM terlebih dahulu , karena user inilah yang berhak membuat user baru . Caranya :. Buat user baru dengan perintah

armand-larson
Download Presentation

BEKERJA DENGAN COMMAND LINE

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. BEKERJA DENGAN COMMAND LINE

  2. MEMBUAT USER • Masukkesql command line, start menu -> all program -> oracle -> Run sqlcommand • Login sebagai SYSTEM terlebihdahulu, karena user inilah yang berhakmembuat user baru. Caranya:

  3. Buat user barudenganperintah SQL>create user [nama_user] identified by [passwordmu]; Contoh Sql>create user stikom identified by medan; Jikaberhasil, kitasudahmenambahsatu user barudengannama user : stikom dengan password : medan Keluardari user system Sql > disconnect

  4. Masukke user stikomdenganmengetikkan • Sql >connect stikom • Password : medan Perhatikanapa yang terjadi ?????? Terjadikesalahan, dimana user stikomtidakmemilikihakaksesdalam database. Untukituharusdisethakdari user stikom. Untukmemberikanhakakseske user stikomandaharus login lagisebagai admin (system) Sql> connect system passwor : Memberikanhakakseske user stikomsepertimembuattabel, membaca, menghapus, menggupdate table Sql >grant connect,resource to stikom;

  5. Loginlahke user stikomdenganlebihdulumemutushubungan user system • Sql > disconnect • Sql>connect stikom password : medan

  6. MEMBUAT TABEL • CREATE TABLE NAMA_TABEL( • KOLOM1 TIPE_DATA(UKURAN) [NOT NULL PRIMARY KEY], • KOLOM2 TIPE_DATA(UKURAN), • …. • KOLOMN TIPE_DATA(UKURAN)); CONTOH TABEL MATAKULIAH KOLOM TIPEDATA UKURAN KET KD_MKUL VARCHAR2 10 TIDAK BOLEH KOSONG DAN PRYMARY KEY NM_MKUL VARCHAR2 20 SKS NUMBER 2

  7. SQL> CREATE TABLE MATAKULIAH ( • KD_MKUL VARCHAR2(10) NOT NULL PRIMARY KEY, • NM_MKUL VARCHAR(20), • SKS NUMBER(3)); Ketikkanperintahberikut : Select * from user_catalog

  8. Tampilkanlahnama_namatabel yang sudahdibuatdenganperintah Select * from user_catalog

More Related