SQL/fromTEST.~sql at master · Savalek/SQL · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
--------ÑÎçäàíèå þçåðà---------
CREATE USER savalek
IDENTIFIED BY a12345
PROFILE DEFAULT;

--------Ïðîñòðàíñòâî----------
CREATE BIGFILE TABLESPACE saval_tablespace
  DATAFILE 'savalek_tablespace01.dat'
  SIZE 20M AUTOEXTEND ON;

--------Èçìåíåíèå þçåðà-------
ALTER USER savalek
DEFAULT TABLESPACE saval_tablespace
IDENTIFIED BY 12345
QUOTA UNLIMITED ON SYSTEM
ACCOUNT UNLOCK;
--TEMPORARY TABLESPACE saval_temp_table

--------Ïðèâèëåãèè--------------
GRANT CREATE SESSION TO savalek;
GRANT CREATE TABLE TO savalek;
GRANT ALTER ANY TABLE TO savalek;
GRANT DELETE ANY TABLE TO savalek;
GRANT SELECT ANY TABLE TO savalek;
GRANT CREATE ANY DIRECTORY TO savalek;
GRANT CREATE ANY SEQUENCE TO savalek;
GRANT SELECT ANY SEQUENCE TO savalek;
GRANT ALTER ANY SEQUENCE TO savalek;
GRANT DROP ANY SEQUENCE TO savalek;
GRANT CREATE ANY PROCEDURE TO savalek;
GRANT ALTER ANY PROCEDURE TO savalek;
GRANT DROP ANY PROCEDURE TO savalek;
GRANT EXECUTE ANY PROCEDURE TO savalek;
GRANT CREATE USER TO savalek;
GRANT ALTER USER TO savalek;
GRANT DROP USER TO savalek;
GRANT CREATE ANY DIRECTORY TO savalek;
GRANT DROP ANY DIRECTORY TO savalek;
GRANT DROP ANY DIRECTORY TO savalek;
GRANT UNLIMITED TABLESPACE TO savalek;
GRANT CREATE ANY VIEW TO savalek;
GRANT DROP ANY VIEW TO savalek;
--dbms_java.revoke_permission ('USER1','java.io.FilePermission','d:\temp\','read,write');
declare
begin
	dbms_java.grant_permission('SAVALEK', 'SYS:java.io.FilePermission', '<<ALL FILES>>', 'read');
  dbms_java.grant_permission('SAVALEK', 'java.net.SocketPermission', '*', 'accept, connect, listen, resolve');
  --dbms_java.grant_permission('SAVALEK', 'java.util.PropertyPermission', '*', 'read,write');
  --dbms_java.revoke_permission('SAVALEK', 'SYS:java.io.FilePermission', 'c:\', 'read, write');
  DBMS_OUTPUT.PUT_LINE('complete');
end;

dbms_java.grant_permission('savalek', 'java.io.FilePermission', 'c:\\', 'read');

-------------Ñîçäàíèå òåñòîâîãî þçåðà------------
DROP USER saval_1;

CREATE USER saval_1
IDENTIFIED BY 12345;

GRANT CREATE SESSION TO saval_1;
GRANT ALTER ANY TABLE TO saval_1;
GRANT SELECT ANY TABLE TO saval_1;
GRANT CREATE TABLE TO saval_1;
GRANT DELETE ANY TABLE TO saval_1;
GRANT EXECUTE ANY PROCEDURE TO saval_1;
GRANT SELECT, INSERT, UPDATE, DELETE ON savalek.people TO saval_1;


REVOKE CREATE SESSION FROM saval_1;