create tablespace ART_TS
     datafile 'c:\Temp\database\sri_mw\sri_mw_01.dbf' size 100M
     extent management local autoallocate segment space management auto;

CREATE USER ARTEM IDENTIFIED BY MANAGER DEFAULT TABLESPACE ART_TS QUOTA UNLIMITED ON ART_TS
/
GRANT CREATE SESSION TO ARTEM
/
GRANT CREATE TABLE TO ARTEM
/
GRANT CREATE PROCEDURE TO ARTEM
/
GRANT CREATE TRIGGER TO ARTEM
/
GRANT CREATE VIEW TO ARTEM
/
GRANT CREATE SEQUENCE TO ARTEM
/
GRANT CREATE VIEW TO ARTEM
/

GRANT DELETE ANY TABLE TO ARTEM
/
GRANT DROP ANY TABLE TO ARTEM
/
GRANT DROP ANY PROCEDURE TO ARTEM
/
GRANT DROP ANY TRIGGER TO ARTEM
/
GRANT DROP ANY VIEW TO ARTEM
/

GRANT ALTER ANY TABLE TO ARTEM
/
GRANT ALTER ANY TABLE TO ARTEM
/
GRANT ALTER ANY PROCEDURE TO ARTEM
/
GRANT ALTER ANY TRIGGER TO ARTEM
/
commit
/