Re: Execute SQL commands in context of another active connection or howto IS_MEMBER for another connected user?

From: Dan Guzman (danguzman_at_nospam-earthlink.net)
Date: 04/29/04 

Date: Wed, 28 Apr 2004 19:44:03 -0500

> Is it possible to execute SQL commands under another active connection.

None that I know of.

> Partly, I interested to get FULL functionality of IS_MEMBER function for
another connected user. I want from my connection to get EXACTLY the same
resault that another user can see runnig IS_MEMBER function, even if there
will be nested SQL roles, nested Windows groups and dbo users. Is it
possible?

A sysadmin role member can execute a SETUSER command to set the security
context of the current connection to the specified login. I haven't tried
this with complex Windows groups/nested role configurations but this might
provide the functionality you want. 

-- 
Hope this helps.
Dan Guzman
SQL Server MVP
"Max" <anonymous@discussions.microsoft.com> wrote in message
news:B0303018-1734-4099-8874-AC77292FDB11@microsoft.com...
> Is it possible to execute SQL commands under another active connection.
>
> I'm connected to SQL server, and want to execute some commands under
another connected user connection. If it possible, which previleges I must
have to do this.
>
> Partly, I interested to get FULL functionality of IS_MEMBER function for
another connected user. I want from my connection to get EXACTLY the same
resault that another user can see runnig IS_MEMBER function, even if there
will be nested SQL roles, nested Windows groups and dbo users. Is it
possible?
>

Relevant Pages

  • Re: Concurrent database access in SQL 2005 Mobile
    ... Please stick to having an "dummy" connection in Open State. ... SQL CE/Mobile has a background thread that flushes the changes ... they run for long hours and we have not seen memory leaks so far. ... then opens his work forms and it's in ...
    (microsoft.public.sqlserver.ce)
  • Re: Concurrent database access in SQL 2005 Mobile
    ... Please stick to having an "dummy" connection in Open State. ... So it is a kind of asynchronous commit which happens every 10 ... I am not sure of this claim as we have many applications built on SQL CE ... then opens his work forms and it's in ...
    (microsoft.public.sqlserver.ce)
  • Access 2003 adp/proxy security - A substitute for SYSTEM_USER()
    ... We need a way for SQL to know the nt username that initiated the proxy ... Many stored procedures and views use a UDF that also depends on ... SyUserLogin and use HostIDand HostName() to find the right row. ... We've played with the Connection dialog settings, ...
    (microsoft.public.access.security)
  • RE: Logging in in background
    ... wold take all kinds of modifictions as I'd need to be checking that each SQL ... my database and all have connection strings associated with them. ... I suspect that there is also an issue on the SQL Server side as I keep ...
    (microsoft.public.access.modulesdaovba)
  • Access 2003 adp/proxy security - A substitute for SYSTEM_USER()
    ... We need a way for SQL to know the nt username that initiated the proxy ... Many stored procedures and views use a UDF that also depends on ... SyUserLogin and use HostIDand HostName() to find the right row. ... We've played with the Connection dialog settings, ...
    (microsoft.public.sqlserver.connect)