Scribd
Upload
64 views1 page

SQL User Management Guide

This document provides instructions for guided modules 12 and 13. For module 12, the instructions are to: 1) log into SQLPlus as the system_a user, 2) create a new GDXXXX user with the password GDXXXX, 3) grant access rights to the new user, 4) run a script from the specified file location as the new user, and 5) delete the new user. For module 13, the instruction is to complete tasks 3, 4, 7, and 9.

Uploaded by

Dewa Ari
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
64 views1 page

SQL User Management Guide

This document provides instructions for guided modules 12 and 13. For module 12, the instructions are to: 1) log into SQLPlus as the system_a user, 2) create a new GDXXXX user with the password GDXXXX, 3) grant access rights to the new user, 4) run a script from the specified file location as the new user, and 5) delete the new user. For module 13, the instruction is to complete tasks 3, 4, 7, and 9.

Uploaded by

Dewa Ari
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
You are on page 1/ 1

GUIDED Modul 12 – 13

Modul 12
1. Buka sqlplus login dengan username: system_a password: basdat_a
2. Buat user baru dengan nama GDXXXX dengan password GDXXXX
3. Berikan hak akses pada user GDXXXX (grant connect, resources, to GDXXXX)
4. Jalankan Script @D:\script_bd.sql (jalankan di dalam user GDXXXX ctt: buka
sqlplus baru masuk dengan user GDXXXX)
5. Hapus user baru yang telah dibuat tadi
Modul 13
Kerjakan nomor 3, 4, 7, 9

You might also like