ode sql>
--A
create user A identified by A;
grant connect to A;
grant create table to A;
grant unlimited ta... e to A;
--B
create user B identified by B;
grant connect to B;
grant create View to B;
--C
create user C identified by C;
grant connect to C;
</code>
Testcase 1
User A:
<code sql>
connect a/A
create table T as select * from all_objects;
g
se aus diesen kleinen Projekt werden auf der APEX Connect 2016 vorgestellt.
**<fc #ff0000>DOAG</fc> - [[https://apex.doag.org/de/| Apex Connect 2016 Konferenz- April 2016]] **\\
26. bis 28. Apr... den Baum aufzubauen:
<code sql>
select case when connect_by_isleaf = 1 then 0 when level = 1 then 1 else -... tp_rel.id)
)
start with parent is null
connect by prior id = parent
order siblings by name
</c
====================+
-- function : connectAD
-- connect to the AD
-- +===================================... rue;
dbms_ldap.utf8_conversion:=false;
-- connect to the ldap server.
v_session := dbms_ldap.in... e => g_ldap_host, portnum => g_ldap_port);
-- connect with this user to the AD
v_retval := dbms_lda... ession;
v_group_tab apex_t_varchar2;
begin
-- connect to LDAP
v_session:=connectad;
-- read the gro
eben:
<code sql>
sqlplus / as sysdba
grant DEBUG CONNECT SESSION to gpi;
grant DEBUG ANY PROCEDURE to gpi;... Port starten, z.B. 4444
begin
DBMS_DEBUG_JDWP.CONNECT_TCP( '127.0.0.1', '4444' );
end;
/
</code>
Der ... ode>
PL/SQL wird ausgeführt: CALL DBMS_DEBUG_JDWP.CONNECT_TCP( 'srvdbgpi01', '5555' )
</code>
Dann muss au
-----------------------------
-- Use Role in SQL
connect gpi
-- check your roles and enable if missing
s... hes SQL eingesetzt werden:
Testcase:
<code sql>
connect gpi
CREATE OR REPLACE PROCEDURE procTestRoleRigh... ber eine View kapseln ===
Testcase:
<code sql>
connect gpi
create view v_local_emp as select * from sco
ema.
..
</code>
D.h. ein Aufruf von:
<code sql>
connect system
rename scott.emp to scott.emp_orig;
ORA... f the table is not allowed
-- Richiger Aufruf:
connect scott
rename semp to emp_orig;
</code>
Eine