FazBrowse GitHub Viewer
|
Trending
|
URL:
|
Home
Tools:
[Download Repo ZIP]
[View Raw Code]
[Original HTTPS Page]
utPLSQL/.github/scripts/create_test_users.sh at develop · utPLSQL/utPLSQL · GitHub
Uh oh!
There was an error while loading.
Please reload this page
.
utPLSQL
/
utPLSQL
Public
Notifications
You must be signed in to change notification settings
Fork
189
Star
622
Code
Issues
12
Pull requests
0
Discussions
Actions
Projects
Security and quality
0
Insights
Additional navigation options
Code
Issues
Pull requests
Discussions
Actions
Projects
Security and quality
Insights
Expand file tree
Breadcrumbs
utPLSQL
/
.github
/
scripts
/
create_test_users.sh
Copy path
More file actions
More file actions
Latest commit
History
History
History
executable file
·
121 lines (93 loc) · 4.75 KB
Breadcrumbs
utPLSQL
/
.github
/
scripts
/
create_test_users.sh
Copy path
File metadata and controls
executable file
·
121 lines (93 loc) · 4.75 KB
Raw
Copy raw file
Download raw file
Open symbols panel
Edit and raw actions
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
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
#!
/bin/bash
set
-ev
SCRIPT_DIR=
"
$(
cd
--
"
$(
dirname --
"
${BASH_SOURCE[0]}
"
)
"
&
>
/dev/null
&&
pwd
)
"
cd
${SCRIPT_DIR}
/../../source
time
"
$SQLCLI
"
sys/
$ORACLE_PWD
@//
$CONNECTION_STR
AS SYSDBA
<<
-
SQL
set feedback off
whenever sqlerror exit failure rollback
--------------------------------------------------------------------------------
PROMPT Adding back create-trigger privilege to
$UT3_DEVELOP_SCHEMA
for testing
grant administer database trigger to
$UT3_DEVELOP_SCHEMA
;
--------------------------------------------------------------------------------
PROMPT Creating UT3_TESTER - Power-user for testing internal framework code
create user UT3_TESTER identified by "ut3" default tablespace
$UT3_TABLESPACE
quota unlimited on
$UT3_TABLESPACE
;
grant create session, create procedure, create type, create table to UT3_TESTER;
# Editioning is enable on test users to validate that utPLSQL works well with editioned schema
alter user UT3_TESTER enable editions;
grant execute on dbms_lock to UT3_TESTER;
PROMPT Granting
$UT3_DEVELOP_SCHEMA
code to UT3_TESTER
begin
for i in (
select object_name from all_objects t
where t.object_type in ('PACKAGE','TYPE')
and owner = '
$UT3_DEVELOP_SCHEMA
'
and generated = 'N'
and object_name not like 'SYS%')
loop
execute immediate 'grant execute on
$UT3_DEVELOP_SCHEMA
."'||i.object_name||'" to UT3_TESTER';
end loop;
end;
/
PROMPT Granting
$UT3_DEVELOP_SCHEMA
tables to UT3_TESTER
begin
for i in ( select table_name from all_tables t where owner = '
$UT3_DEVELOP_SCHEMA
' and nested = 'NO' and iot_name is null)
loop
execute immediate 'grant select on
$UT3_DEVELOP_SCHEMA
.'||i.table_name||' to UT3_TESTER';
end loop;
end;
/
--------------------------------------------------------------------------------
PROMPT Creating UT3_USER - minimal privileges user for API testing
create user UT3_USER identified by "ut3" default tablespace
$UT3_TABLESPACE
quota unlimited on
$UT3_TABLESPACE
;
grant create session, create procedure, create type, create table to UT3_USER;
# Editioning is enable on test users to validate that utPLSQL works well with editioned schema
alter user UT3_USER enable editions;
PROMPT Grants for starting a debugging session from UT3_USER
grant debug connect session to UT3_USER;
grant debug any procedure to UT3_USER;
begin
\$
if dbms_db_version.version <= 11
\$
then
null; -- no addition action necessary
\$
else
-- necessary on 12c or higher
dbms_network_acl_admin.append_host_ace (
host =>'*',
ace => sys.xs
\$
ace_type(
privilege_list => sys.xs
\$
name_list('JDWP') ,
principal_name => 'UT3_USER',
principal_type => sys.xs_acl.ptype_db
)
);
\$
end
end;
/
--------------------------------------------------------------------------------
PROMPT Creating UT3_TESTER_HELPER - provides functions to allow min grant test user setup tests.
create user UT3_TESTER_HELPER identified by "ut3" default tablespace
$UT3_TABLESPACE
quota unlimited on
$UT3_TABLESPACE
;
grant create session, create procedure, create type, create table to UT3_TESTER_HELPER;
PROMPT Grants for testing distributed transactions
grant create public database link to UT3_TESTER_HELPER;
grant drop public database link to UT3_TESTER_HELPER;
PROMPT Grants for testing coverage outside of main
$UT3_DEVELOP_SCHEMA
schema.
grant create any procedure, drop any procedure, execute any procedure, create any type, drop any type, execute any type, under any type,
select any table, update any table, insert any table, delete any table, create any table, drop any table, alter any table,
select any dictionary, create any synonym, drop any synonym,
grant any object privilege, grant any privilege, create public synonym, drop public synonym, create any trigger, drop any trigger
to UT3_TESTER_HELPER;
grant create job to UT3_TESTER_HELPER;
PROMPT Additional grants for disabling DDL trigger and testing parser without trigger enabled/present
grant alter any trigger to UT3_TESTER_HELPER;
grant administer database trigger to UT3_TESTER_HELPER;
grant execute on dbms_lock to UT3_TESTER_HELPER;
create user ut3_cache_test_owner identified by ut3;
grant create session, create procedure to ut3_cache_test_owner;
create user ut3_no_extra_priv_user identified by ut3;
grant create session, create procedure to ut3_no_extra_priv_user;
create user ut3_select_catalog_user identified by ut3;
grant create session, create procedure, select_catalog_role to ut3_select_catalog_user;
create user ut3_select_any_table_user identified by ut3;
grant create session, create procedure, select any table to ut3_select_any_table_user;
create user ut3_execute_any_proc_user identified by ut3;
grant create session, create procedure, execute any procedure to ut3_execute_any_proc_user;
exit
SQL
Back
|
FazBrowse Home
|
New Git URL