CREATE TABLE videokazety
(
    ev_cislo  NUMBER(4) PRIMARY KEY,
    nazev     VARCHAR2(15) 
);

INSERT INTO videokazety VALUES(1, 'Pocahontas');
INSERT INTO videokazety VALUES(2, 'Lion King');
INSERT INTO videokazety VALUES(3, 'Cinderella');
COMMIT;



-- 1. krok: vytvome nov uivatele
  CREATE USER adam IDENTIFIED BY adam PASSWORD EXPIRE;
  CREATE USER bozena IDENTIFIED BY bozena PASSWORD EXPIRE;
  CREATE USER cyril IDENTIFIED BY cyril PASSWORD EXPIRE;

--2. krok: vytvome roli ARCHIVAR
  CREATE ROLE archivar;

--3. krok: roli ARCHIVAR pidlme oprvnn dan rolemi CONNECT a RESOURCE
  GRANT connect, resource TO archivar;

--4. krok: nov vytvoenm uivatelm pidlme roli ARCHIVAR
  GRANT archivar TO adam, bozena, cyril;

-- 5. krok: roli ARCHIVAR pidlme objektov oprvnn pro tabulky EMP a DEPT
-- objektov oprvnn me obvykle pidlit jen vlastnk danho objektu 
  CONNECT scott/tiger;
  GRANT select ON "SCOTT"."EMP" TO archivar;
  GRANT select ON "SCOTT"."DEPT" TO archivar;


