Skip to content
Merged
Changes from 1 commit
Commits
File filter

Filter by extension

Filter by extension

Conversations
Failed to load comments.
Loading
Jump to
Jump to file
Failed to load files.
Loading
Diff view
Diff view
Prev Previous commit
support Oracle DB 11.2, add ace only on 12c and higher
  • Loading branch information
PhilippSalvisberg committed Jun 4, 2020
commit 6631930da1a70d26f2f828b6c061292f577f39ad
23 changes: 14 additions & 9 deletions .travis/install.sh
Original file line number Diff line number Diff line change
Expand Up @@ -115,18 +115,23 @@ grant create session, create procedure, create type, create table to $UT3_USER;

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
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
)
);
\$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;
/
grant debug any procedure to $UT3_USER;

--------------------------------------------------------------------------------
PROMPT Creating $UT3_TESTER_HELPER - provides functions to allow min grant test user setup tests.
Expand Down