Item mit einem Namen, wie in unseren Fall "P73_DBUSERNAME", anlegen und auf den Typ "Hidden" setzen.
In di... iner Bindvariablen hinterlegen:
<code sql>
select username
, os_username
, userhost
, terminal
, to_char(extended_timestamp,'dd.mm.yyyy hh24:mi')... IV_USED
from v_page_73_auditlog_details
where username=:P73_DBUSERNAME
order by extended_timestamp des
d einbinden:
<code sql>
declare
cursor c_role(p_username varchar2)
is
select USERNAME
, rtrim ( xmlagg (xmlelement (c,GRANTED_ROLE || ',') ORDER B... e_list
from user_role_privs
where USERNAME=p_username
group by USERNAME;
begin
htp.p('You are :: <span style="font-weight: bold; color :
=> 1,
p_username => 'SYSTEM',
... -- ========================================
v_username varchar2(32);
v_sql varchar2(4000);
v... den aktuellen aPEX Owner aus der DB
select max(username)
into v_username
from dba_users
where regexp_like(username,'^APEX_[[:digit:]].*');
if v_k
nistrator privileges.
Enter the administrator username: sys
Enter the database password for SYS AS SYS... d in configuration: default
The setting named: db.username was set to: ORDS_PUBLIC_USER in configuration: de... SRV_GPIDB_MAIN Pool
db.username ORDS_PUBLIC_USER ... 2021-03-27 17:20:43
select username,default_tablespace, temporary_tablespace from dba
<code xml>
<role rolename="manager-gui"/>
<user username="tomcat" password="geheim" roles="manager-gui"/>
... fen ob nicht ein alter APEX Stand exisiert
select username from dba_users;
#falls ja mit @apxremov aus dem O... nistrator privileges.
Enter the administrator username: sys
Enter the database password for SYS AS SYS... d in configuration: default
The setting named: db.username was set to: ORDS_PUBLIC_USER in configuration: de
er varchar2(256):='mail.mydoamin.de';
v_mail_username varchar2(200):='my_user@mydoamin.de';
-- not ... _line('--Info : login to the Mail server with the username::'||v_mail_username);
v_reply:= UTL_SMTP.AUTH (
c => v_con
, username => v_mail_username
, password =>
<code xml>
<role rolename="manager-gui"/>
<user username="tomcat" password="geheim" roles="manager-gui"/>
... uireAll>
# use this to add the authenticated username to you header
# so any backend system can fet... v -k https://myapexserver/ords/ --ntlm -u DOMAIN\\username:password
</code>
=== Kerberos auf Tomcat Eb... egen}}
* Hinterlegen in welchen Header Feld der Username steht {{ :prog:apex:apex_single_sign_on_04.png?di
0.1
db.port=1521
db.servicename=GPI
db.sid=GPI
db.username=APEX_PUBLIC_USER
migrate.apex.rest=false
rest.ser... s schema. Installation may be required.
Enter the username with SYSDBA privileges to verify the installation... ST Data Services schema.
Enter the administrator username:sys
Enter the database password for SYS AS SYSDBA
GIT_HOME%\cmd\git.exe" commit -m "Commit done by %USERNAME% at %DATE% %TIME%"
"%GIT_HOME%\cmd\git.exe" push
... _HOME\cmd\git.exe" commit -m "Commit done by $env:UserName at $datum"
& "$ENV:GIT_HOME\cmd\git.exe" push
</... erwendt als User Home den Windows Pfad (C:\Users\<username>) und legt dort die .gitconfig an.
Globale Konf
ler - Wizard Connection Dialog "ORA-01017:invalid username/password; logon denied" ===
{{ :prog:dot-net-i... User Wizard Deploy Oracle .Net ORA-01017:invalid username/password; logon denied }}
Hier MUSS zwingend der... dung mit dem falschen Passwort (ORA-01017:invalid username/password; logon denied) ist dann sehr missverstän
aiter ******************/
select ss.sid
, ss.username
, ss.terminal
, ss.program
, sw.event...
/**** Suchen über die v$lock und die X$KGLLK mit Username der blockierenden Session ***/
SELECT * FROM X$KG