Wednesday, December 22, 2021

How to create a native login in azure

 

create login DAV4635 with password='YourPassword';


create user DAV4635 from login DAV4635;


USE AEDIDACATED

EXEC sp_addrolemember N'db_owner', N'DAV4635'

GO

__


-- ADD AD USER



  CREATE USER [dexter.soreta@aei.com] 

FROM EXTERNAL PROVIDER 

WITH DEFAULT_SCHEMA = dbo;  





EXEC sp_addrolemember N'db_datareader', N'dexter.soreta@aei.com'


Monday, December 13, 2021

BARBATOS /u01

 ./wind_ora_25225_20211214011600673492885833.aud

./wind_ora_25236_20211214011601236794820192.aud

[oracle@barbatos adump]$ pwd

/u01/app/oracle/admin/wind/adump

[oracle@barbatos adump]$ find . -name "*.aud" -delete