1,642
Are there any hints on how to use the current userid value inside a QuickQuery view?
I've been trying to use the PES table, but I don't really understand how it works.
I'm setting up a view using the built in SQL funcions like SYSTEM_USER and CURRENT_USER. I'm using a Windows based authentication scheme, so this should work. I still can't get a working query though.
Thanks in advance.
*This post is locked for comments
Ok, I finally hacked into it.
I never really understood the 07718158D19D4f5f9D23B55DBF5DF1 and E8F575915A2E4897A517779C0DD7CE tweaks. It seems that the QQVIE00.EXE process establish a proper SL environment and then starts an anonymous .Net SqlClient Data Provider session to fetch the data. So, you should be able to locate other SQL processes that are originated from the same client QQVIE00 process, a value available through the host_id() built in function.
This approach sould work only under some conditions.
I think this is against Quick Query intended focus. What I need is an outlook grid showing "My transactions" with drill down and excel-export capabilities. Role center should be a contendor for this.
Share
Report
All responses (
Answers (
/*******************************************************************
xQQ_User()
Returns the Application User currently querying a QQ view
Notes:
This works for Windows Authentication mode
SL 2011 itself executes the QQ query under an anonymous session.
This function does a redirection searching for the authenticated
user owner of the same QQVIEW00 process in the client
machine.
This should work only under specific scenarios under the SL full
client.
********************************************************************/
create function xQQ_User() returns char(47)
with execute as '07718158D19D4f5f9D23B55DBF5DF1'
as
begin
return (
select userid
from dbo.vs_userrec
where WindowsUserAcct = (
select max(loginame)
from sys.sysprocesses
where hostname like HOST_NAME() + '%' and
hostprocess=host_id() and
spid <> @@spid
)
) ;
end;
I am revisiting this issue. It seems that the SQL session that executes the query is always the E8F575915A2E4897A517779C0DD7CE user. There's no context change and no host information. There is no PES record either.
So, the QQ execution seems strictly anonymous for the time being.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,214
Most Valuable Professional
#3
nmaenpaa
101,156