-- clean all
DROP ROLE "STAGE_SGBD" CASCADE;
DROP USER "STAGE1" CASCADE;
DROP USER "STAGE2" CASCADE;
DROP USER "STAGE3" CASCADE;
DROP USER "STAGE4" CASCADE;
DROP USER "STAGE5" CASCADE;
DROP USER "STAGE6" CASCADE;
DROP USER "STAGE7" CASCADE;
DROP USER "STAGE8" CASCADE;
DROP USER "STAGE9" CASCADE;
DROP USER "STAGE10" CASCADE;
DROP USER "STAGE11" CASCADE;
DROP USER "STAGE12" CASCADE;
DROP USER "STAGE13" CASCADE;
DROP USER "STAGE14" CASCADE;
DROP USER "STAGE15" CASCADE;
DROP USER "STAGE16" CASCADE;
DROP USER "STAGE17" CASCADE;
DROP USER "STAGE18" CASCADE;
DROP USER "STAGE19" CASCADE;
DROP USER "STAGE20" CASCADE;

-- Création du role
CREATE ROLE "STAGE_SGBD"  NOT IDENTIFIED;
GRANT "CONNECT" TO "STAGE_SGBD";
GRANT "RESOURCE" TO "STAGE_SGBD";
GRANT "SELECT_CATALOG_ROLE" TO "STAGE_SGBD";


--Création des users
CREATE USER "STAGE1"  
     PROFILE "DEFAULT" 
     IDENTIFIED BY "STAGE1" 
     DEFAULT TABLESPACE "USERS" 
     TEMPORARY TABLESPACE "TEMP" 
     ACCOUNT UNLOCK;

GRANT "STAGE_SGBD" TO "STAGE1";
ALTER USER "STAGE1" DEFAULT ROLE  ALL;
ALTER USER "STAGE1"  QUOTA UNLIMITED ON TEMP QUOTA UNLIMITED ON USERS;




CREATE USER "STAGE2"  
     PROFILE "DEFAULT" 
     IDENTIFIED BY "STAGE2" 
     DEFAULT TABLESPACE "USERS" 
     TEMPORARY TABLESPACE "TEMP" 
     ACCOUNT UNLOCK;

GRANT "STAGE_SGBD" TO "STAGE2";
ALTER USER "STAGE2" DEFAULT ROLE  ALL;
ALTER USER "STAGE2"  QUOTA UNLIMITED ON TEMP QUOTA UNLIMITED ON USERS;

CREATE USER "STAGE3"  
     PROFILE "DEFAULT" 
     IDENTIFIED BY "STAGE3" 
     DEFAULT TABLESPACE "USERS" 
     TEMPORARY TABLESPACE "TEMP" 
     ACCOUNT UNLOCK;

GRANT "STAGE_SGBD" TO "STAGE3";
ALTER USER "STAGE3" DEFAULT ROLE  ALL;
ALTER USER "STAGE3"  QUOTA UNLIMITED ON TEMP QUOTA UNLIMITED ON USERS;


CREATE USER "STAGE4"  
     PROFILE "DEFAULT" 
     IDENTIFIED BY "STAGE4" 
     DEFAULT TABLESPACE "USERS" 
     TEMPORARY TABLESPACE "TEMP" 
     ACCOUNT UNLOCK;

GRANT "STAGE_SGBD" TO "STAGE4";
ALTER USER "STAGE4" DEFAULT ROLE  ALL;
ALTER USER "STAGE4"  QUOTA UNLIMITED ON TEMP QUOTA UNLIMITED ON USERS;


CREATE USER "STAGE5"  
     PROFILE "DEFAULT" 
     IDENTIFIED BY "STAGE5" 
     DEFAULT TABLESPACE "USERS" 
     TEMPORARY TABLESPACE "TEMP" 
     ACCOUNT UNLOCK;

GRANT "STAGE_SGBD" TO "STAGE5";
ALTER USER "STAGE5" DEFAULT ROLE  ALL;
ALTER USER "STAGE5"  QUOTA UNLIMITED ON TEMP QUOTA UNLIMITED ON USERS;


CREATE USER "STAGE6"  
     PROFILE "DEFAULT" 
     IDENTIFIED BY "STAGE6" 
     DEFAULT TABLESPACE "USERS" 
     TEMPORARY TABLESPACE "TEMP" 
     ACCOUNT UNLOCK;

GRANT "STAGE_SGBD" TO "STAGE6";
ALTER USER "STAGE6" DEFAULT ROLE  ALL;
ALTER USER "STAGE6"  QUOTA UNLIMITED ON TEMP QUOTA UNLIMITED ON USERS;


CREATE USER "STAGE7"  
     PROFILE "DEFAULT" 
     IDENTIFIED BY "STAGE7" 
     DEFAULT TABLESPACE "USERS" 
     TEMPORARY TABLESPACE "TEMP" 
     ACCOUNT UNLOCK;

GRANT "STAGE_SGBD" TO "STAGE7";
ALTER USER "STAGE7" DEFAULT ROLE  ALL;
ALTER USER "STAGE7"  QUOTA UNLIMITED ON TEMP QUOTA UNLIMITED ON USERS;


CREATE USER "STAGE8"  
     PROFILE "DEFAULT" 
     IDENTIFIED BY "STAGE8" 
     DEFAULT TABLESPACE "USERS" 
     TEMPORARY TABLESPACE "TEMP" 
     ACCOUNT UNLOCK;

GRANT "STAGE_SGBD" TO "STAGE8";
ALTER USER "STAGE8" DEFAULT ROLE  ALL;
ALTER USER "STAGE8"  QUOTA UNLIMITED ON TEMP QUOTA UNLIMITED ON USERS;


CREATE USER "STAGE9"  
     PROFILE "DEFAULT" 
     IDENTIFIED BY "STAGE9" 
     DEFAULT TABLESPACE "USERS" 
     TEMPORARY TABLESPACE "TEMP" 
     ACCOUNT UNLOCK;

GRANT "STAGE_SGBD" TO "STAGE9";
ALTER USER "STAGE9" DEFAULT ROLE  ALL;
ALTER USER "STAGE9"  QUOTA UNLIMITED ON TEMP QUOTA UNLIMITED ON USERS;


CREATE USER "STAGE10"  
     PROFILE "DEFAULT" 
     IDENTIFIED BY "STAGE10" 
     DEFAULT TABLESPACE "USERS" 
     TEMPORARY TABLESPACE "TEMP" 
     ACCOUNT UNLOCK;

GRANT "STAGE_SGBD" TO "STAGE10";
ALTER USER "STAGE10" DEFAULT ROLE  ALL;
ALTER USER "STAGE10"  QUOTA UNLIMITED ON TEMP QUOTA UNLIMITED ON USERS;


CREATE USER "STAGE11"  
     PROFILE "DEFAULT" 
     IDENTIFIED BY "STAGE11" 
     DEFAULT TABLESPACE "USERS" 
     TEMPORARY TABLESPACE "TEMP" 
     ACCOUNT UNLOCK;

GRANT "STAGE_SGBD" TO "STAGE11";
ALTER USER "STAGE11" DEFAULT ROLE  ALL;
ALTER USER "STAGE11"  QUOTA UNLIMITED ON TEMP QUOTA UNLIMITED ON USERS;

CREATE USER "STAGE12"  
     PROFILE "DEFAULT" 
     IDENTIFIED BY "STAGE12" 
     DEFAULT TABLESPACE "USERS" 
     TEMPORARY TABLESPACE "TEMP" 
     ACCOUNT UNLOCK;

GRANT "STAGE_SGBD" TO "STAGE12";
ALTER USER "STAGE12" DEFAULT ROLE  ALL;
ALTER USER "STAGE12"  QUOTA UNLIMITED ON TEMP QUOTA UNLIMITED ON USERS;

CREATE USER "STAGE13"  
     PROFILE "DEFAULT" 
     IDENTIFIED BY "STAGE13" 
     DEFAULT TABLESPACE "USERS" 
     TEMPORARY TABLESPACE "TEMP" 
     ACCOUNT UNLOCK;

GRANT "STAGE_SGBD" TO "STAGE13";
ALTER USER "STAGE13" DEFAULT ROLE  ALL;
ALTER USER "STAGE13"  QUOTA UNLIMITED ON TEMP QUOTA UNLIMITED ON USERS;

CREATE USER "STAGE14"  
     PROFILE "DEFAULT" 
     IDENTIFIED BY "STAGE14" 
     DEFAULT TABLESPACE "USERS" 
     TEMPORARY TABLESPACE "TEMP" 
     ACCOUNT UNLOCK;

GRANT "STAGE_SGBD" TO "STAGE14";
ALTER USER "STAGE14" DEFAULT ROLE  ALL;
ALTER USER "STAGE14"  QUOTA UNLIMITED ON TEMP QUOTA UNLIMITED ON USERS;


CREATE USER "STAGE15"  
     PROFILE "DEFAULT" 
     IDENTIFIED BY "STAGE15" 
     DEFAULT TABLESPACE "USERS" 
     TEMPORARY TABLESPACE "TEMP" 
     ACCOUNT UNLOCK;

GRANT "STAGE_SGBD" TO "STAGE15";
ALTER USER "STAGE15" DEFAULT ROLE  ALL;
ALTER USER "STAGE15"  QUOTA UNLIMITED ON TEMP QUOTA UNLIMITED ON USERS;

CREATE USER "STAGE16"  
     PROFILE "DEFAULT" 
     IDENTIFIED BY "STAGE16" 
     DEFAULT TABLESPACE "USERS" 
     TEMPORARY TABLESPACE "TEMP" 
     ACCOUNT UNLOCK;

GRANT "STAGE_SGBD" TO "STAGE16";
ALTER USER "STAGE16" DEFAULT ROLE  ALL;
ALTER USER "STAGE16"  QUOTA UNLIMITED ON TEMP QUOTA UNLIMITED ON USERS;

CREATE USER "STAGE17"  
     PROFILE "DEFAULT" 
     IDENTIFIED BY "STAGE17" 
     DEFAULT TABLESPACE "USERS" 
     TEMPORARY TABLESPACE "TEMP" 
     ACCOUNT UNLOCK;

GRANT "STAGE_SGBD" TO "STAGE17";
ALTER USER "STAGE17" DEFAULT ROLE  ALL;
ALTER USER "STAGE17"  QUOTA UNLIMITED ON TEMP QUOTA UNLIMITED ON USERS;

CREATE USER "STAGE18"  
     PROFILE "DEFAULT" 
     IDENTIFIED BY "STAGE18" 
     DEFAULT TABLESPACE "USERS" 
     TEMPORARY TABLESPACE "TEMP" 
     ACCOUNT UNLOCK;

GRANT "STAGE_SGBD" TO "STAGE18";
ALTER USER "STAGE18" DEFAULT ROLE  ALL;
ALTER USER "STAGE18"  QUOTA UNLIMITED ON TEMP QUOTA UNLIMITED ON USERS;

CREATE USER "STAGE19"  
     PROFILE "DEFAULT" 
     IDENTIFIED BY "STAGE19" 
     DEFAULT TABLESPACE "USERS" 
     TEMPORARY TABLESPACE "TEMP" 
     ACCOUNT UNLOCK;

GRANT "STAGE_SGBD" TO "STAGE19";
ALTER USER "STAGE19" DEFAULT ROLE  ALL;
ALTER USER "STAGE19"  QUOTA UNLIMITED ON TEMP QUOTA UNLIMITED ON USERS;

CREATE USER "STAGE20"  
     PROFILE "DEFAULT" 
     IDENTIFIED BY "STAGE20" 
     DEFAULT TABLESPACE "USERS" 
     TEMPORARY TABLESPACE "TEMP" 
     ACCOUNT UNLOCK;

GRANT "STAGE_SGBD" TO "STAGE20";
ALTER USER "STAGE20" DEFAULT ROLE  ALL;
ALTER USER "STAGE20"  QUOTA UNLIMITED ON TEMP QUOTA UNLIMITED ON USERS;


-- Vérification 

select username from all_users
order by username
/