Drunik,
у вас нерепрезентативно представлен набор данных по трассе,
включите события:
SecurityAudit:Audit Login
Security Audit: Audit Logout
Security Audit: Audit Database Principal Impersonation Event
Security Audit: Audit Server Principal Impersonation Event
Stored Procedures: RPC:Completed
Stored Procedures: RPC:Starting
Stored Procedures: SP:Completed
Stored Procedures: SP:Starting
Stored Procedures: SP:StmtCompleted
TSQL: Exec Prepared SQL
TSQL: SQL:Batch Completed
TSQL: SQL:StmtStarting
TSQL: SQL:StmtCompleted
и для них колонки в порядке:
SPID, ApplicationName, LoginName, ObjectName, TextData, Database ID, Transaction ID
я у себя такой тест провел:
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
16.
17.
18.
19.
20.
21.
22.
23.
24.
25.
26.
27.
using System;
using System.Data;
using System.Data.SqlClient;
using System.Data.SqlTypes;
using Microsoft.SqlServer.Server;
public partial class StoredProcedures
{
[Microsoft.SqlServer.Server.SqlProcedure]
public static void ImplTestCLR(string srv, string db)
{
var b = new SqlConnectionStringBuilder()
{
ApplicationName = "CLR", DataSource = srv, InitialCatalog=db, IntegratedSecurity=true, Enlist=false, PersistSecurityInfo=false, ConnectTimeout=10
};
using (var cn = new SqlConnection(b.ToString()))
{
cn.Open();
using (var cmd = new SqlCommand("imp_test", cn) { CommandType = CommandType.StoredProcedure})
{
cmd.ExecuteNonQuery();
}
}
}
}
1.
2.
3.
4.
5.
6.
create or alter procedure [imp_test]
with execute as owner
as
declare @t table (id int)
insert into @t values (1);
go
это выполняется в контексте пользовательской сессии SQL LOGIN
1.
2.
3.
4.
5.
6.
declare @srv sysname = @@SERVERNAME, @db sysname = DB_NAME();
select original_login() as [org], suser_name() as [cur], user_name() as [usr];
exec [ImplTestCLR] @srv, @db;
select original_login() as [org], suser_name() as [cur], user_name() as [usr];
у меня на Microsoft SQL Server 2019 (RTM) - 15.0.2000.5 (X64) Sep 24 2019 13:48:23 Copyright (C) 2019 Microsoft Corporation Express Edition (64-bit) on Windows 10 Pro 10.0 <X64> (Build 18362: )
все нормально возвращается в контекст пользователя
