获取DOTNETNUKE当前用户信息使用存储过程 [英] Get DOTNETNUKE Current User info Using Stored Procedures

问题描述

我是Satish ...........



如何使用Sql中的存储过程获取当前登录的dnn用户信息服务器？



先谢谢............

Hi, I am Satish...........

How to get current logged in user info of dnn using Stored Procedures in Sql Server?

Thanks in Advance............

推荐答案

使用这个。

use this one.

SELECT  SUSER_NAME()

检查以下数据库触发器脚本

Hi ,

Check the following Database Trigger Script

CREATE TRIGGER [DDLTrigger_Sample]
    ON DATABASE
    FOR CREATE_PROCEDURE, ALTER_PROCEDURE, DROP_PROCEDURE
AS
BEGIN
    SET NOCOUNT ON;
    DECLARE @EventData XML = EVENTDATA();
 
    DECLARE @ip VARCHAR(32) =  (
            SELECT client_net_address
                FROM sys.dm_exec_connections
                WHERE session_id = @@SPID
        );
 
    INSERT AuditDB.dbo.DDLEvents
    (
        EventType,
        EventDDL,
        EventXML,
        DatabaseName,
        SchemaName,
        ObjectName,
        HostName,
        IPAddress,
        ProgramName,
        LoginName
    )
    SELECT
        @EventData.value('(/EVENT_INSTANCE/EventType)[1]',   'NVARCHAR(100)'), 
        @EventData.value('(/EVENT_INSTANCE/TSQLCommand)[1]', 'NVARCHAR(MAX)'),
        @EventData,
        DB_NAME(),
        @EventData.value('(/EVENT_INSTANCE/SchemaName)[1]',  'NVARCHAR(255)'), 
        @EventData.value('(/EVENT_INSTANCE/ObjectName)[1]',  'NVARCHAR(255)'),
        HOST_NAME(),
        @ip,
        PROGRAM_NAME(),
        SUSER_SNAME();
END

问候，

GVPrabu

Regards,
GVPrabu

这篇关于获取DOTNETNUKE当前用户信息使用存储过程的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！