How to get current logged in user info of dnn using Stored Procedures in Sql Server?
如何使用存储过程获得当前登录的DNN用户信息，这些信息会保存在SQL服务器上？
Solution1 解决方法1
Use this code to see what happens.
使用这一个代码看看会发生什么情况。
SELECT SUSER_NAME()
Solution2 解决方案2
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
Get DOTNETNUKE Current User info Using Stored Procedures Is not difficult, we can try to solve the above two methods. note:(Step stored procedure: create a stored procedure, execute, delete stored procedures, modify the stored procedure.)
使用存储过程获取DotNetNuke当前用户信息并不困难，我们可以尝试使用上述两种方法。注意：（存储过程的步骤：创建存储过程、执行、删除存储过程、修改存储过程。）