belajar dasar sql

perintah create user :
--------------------------------
create user user
identified by password

grant connect,resource to scott;


--------------------------------
perintah hapus user :
--------------------------------
DROP USER scott [CASCADE]



--------------------------------
Mengubah Password user :
--------------------------------
ALTER USER scott
IDENTIFIED BY lion;


---------------------------
Lock & Unlock user :
---------------------------
create user jack identified by jack account lock


--------------------------
mengunlock :
--------------------------
alter user jack account unlock


--------------------------------
Melihat status akun user :
--------------------------------
select username,account_status,lock_date
from dba_users where username='JACK';



------------------------------
Mencabut hak akses user :
------------------------------
revoke connect from jack


slide 2:
=============
 System privilege : hak akase user untuk menjalankan perintah atau 
      hak akses database
 
 contoh :
 GRANT create session,create table,
       create sequence,create view
        TO scott;

buat table 
..................

 create table table1(
 Nama varchar2(25)
 );
 
 insert into table1 values ();

-------------------------------------------------------------------

  Object privilege: 
 GRANT select 
 ON employees
 TO scott,jack;
-------------------------------------------------------------------
  Role : merupakan group priveleege untuk meberikan hak akses ke beberapa
  user.

  create role manager ;
  grant create table,create view TO manager;
  grant manager to  nazip,zihni;