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'
./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
BEGIN
FOR r IN (select sid,serial# from v$session where username='COMPASS')
LOOP
EXECUTE IMMEDIATE 'alter system kill session ''' || r.sid || ','
|| r.serial# || ''' immediate';
END LOOP;
END;
On SQL Server, requires VIEW SERVER STATE and ALTER TRACE permissions. On Azure SQL Database, requires the VIEW DATABASE STATE permission in the database.
--current connections
SELECT @@ServerName AS server
,NAME AS dbname
,COUNT(STATUS) AS number_of_connections
,GETDATE() AS timestamp
FROM sys.databases sd
LEFT JOIN sysprocesses sp ON sd.database_id = sp.dbid
WHERE database_id NOT BETWEEN 1 AND 4
GROUP BY NAME;
--db last accessed
SELECT d.name,
last_user_seek = MAX(last_user_seek),
last_user_scan = MAX(last_user_scan),
last_user_lookup = MAX(last_user_lookup),
last_user_update = MAX(last_user_update)
FROM sys.dm_db_index_usage_stats AS i
JOIN sys.databases AS d ON i.database_id=d.database_id
GROUP BY d.name
--last restart
SELECT sqlserver_start_time FROM sys.dm_os_sys_info
select Session_ID = session_id
,Command = command
,Start_Time = start_time
,Status = status
,Percent_Completed = percent_complete
,Time_In_Min = (estimated_completion_time/60000)
,Elapsed_Time_Minutes = (total_elapsed_time/60000)
,Wait_Type = wait_type
,Last_Wait_type = last_wait_type
,Blocking_Session = Blocking_Session_Id
,Reads = reads
,Writes = writes
,Logical_Reads = logical_reads
from sys.dm_exec_requests
where session_id > 50
part1i tns was wrong
