Social Icons

martes, 28 de junio de 2022

Depurar Usuarios OpenWells

 SELECT * FROM ALVEARC.TABLE_UADOW

ALTER TABLE ALVEARC.TABLE_UADOW MODIFY CUENTA VARCHAR2(100);


UPDATE MD_SITE_USER SET IS_DISABLED='Y' WHERE USER_OR_GROUP='U'


MERGE into EDMADMIN.MD_SITE_USER t1

using (SELECT * FROM ALVEARC.TABLE_UADOW) t2

on (UPPER(t1.USER_NAME)=UPPER(t2.CUENTA))

when matched then 

update set t1.is_disabled='N'

where t1.user_or_group='U'


Descargar cliente de Oracle 19c

  Oracle Database 19c Download for Microsoft Windows x64 (64-bit) https://www.oracle.com/database/technologies/oracle19c-windows-downloads.html

 
 
Blogger Templates