Latihan Soal BASDAT lanjut

Username : Snake   Basis Data : Company
Host : 10.10.13.1   Tabel : Employees
Pass : MGS     Departments

1. perintah utk membuat user
   CREATE USER Snake@10.10.13.1 identified by 'MGS';


2. kewenangan pd user SNake utk memasukkan data ditabel Employees saja
   GRANT INSERT on Company.employees to Snake@10.10.13.1 identified by 'MGS';

3. kewenangan pd user Snake utk menghapus data di semua tabel pada basis data Company
   GRANT DELETE on Company.*to Snake@10.10.13.1 identified by 'MGS';

4. ambil kewenangan user Snake utk menghapus data pada tabel Departments
   REVOKE DELETE on Company.DEpartments from Snake@10.10.13.1;

5. perintah utk menghapus user Snake
   DROP USER Snake@10.10.13.1;
   DELERE FROM USER WHERE USER='Snake' and host='10.10.13.1