When a user account is created on SQLServer on 2005 with user account set to "Enforce password policy" and "Enforce password expiration", once set this policy and expiration can't be changed using. ALTER LOGIN test WITH CHECK_EXPIRATION = OFF; Or ALTER LOGIN test WITH CHECK_POLICY = OFF; SQLserver will return the following message Msg 15128, … Continue reading The CHECK_POLICY and CHECK_EXPIRATION options cannot be turned OFF when MUST_CHANGE is ON
Tag: off
Using oradebug to set event
The following example shows how to set event on a oracle session To turn on event, needs to be run as sysdba SQL> connect /as sysdba – attach to session by OS process id SQL> oradebug setospid 5243378; Oracle pid: 68, Unix process pid: 5243378, image: oracle@hostname (TNS V1-V3) – sets maximum dump file size … Continue reading Using oradebug to set event
How to turn trace and set events using dbms_system?
To turn on trace for a specific event. exec dbms_system.set_ev(<SID>, <serial#>, <event>, 8, ''); Example: Enable trace at level 8 for session id 10046 exec dbms_system.set_ev(12345, 543211, 10046, 8, ''); -- To turn off the tracing: exec dbms_system.set_ev(<SID>, <serial#>, <event>, 0, ''); Example: exec dbms_system.set_ev( 1234, 56789, 10046, 0, '');