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

From: Max (anonymous_at_discussions.microsoft.com)
Date: 04/28/04

  • Next message: Sue Hoegemeier: "Re: Granting EXEC to all my user sprocs in one hit" 
    Date: Wed, 28 Apr 2004 08:56:04 -0700

    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?

  • Next message: Sue Hoegemeier: "Re: Granting EXEC to all my user sprocs in one hit"

    Relevant Pages

    • Re: Execute SQL commands in context of another active connection or howto IS_MEMBER for another conn
      ... > Is it possible to execute SQL commands under another active connection. ... will be nested SQL roles, nested Windows groups and dbo users. ...
      (microsoft.public.sqlserver.security)
    • Re: Error "SQL Server does not allow remote connections"
      ... The application could not connect to the sql server db. ... network is blocking the connection. ... SqlInternalConnectionTds connHandler, Boolean ignoreSniOpenTimeout, Int64 ... integratedSecurity, SqlConnection owningObject) +737554 ...
      (microsoft.public.dotnet.framework.aspnet)
    • Re: Connection from remote computer to network SQL Server
      ... There is no firewall on the W2K machine acting as the SQL server. ... I tried making the SQL machine a "trusted" on the router. ... connection works. ... To find the IP address of your computer inside the network, ...
      (microsoft.public.access.adp.sqlserver)
    • ADO.net Orcas Samples Install Problem
      ... An error has occurred while establishing a connection to the server. ... When connecting to SQL Server 2005, this failure may be caused by the ... SqlInternalConnectionTds connHandler, Boolean ignoreSniOpenTimeout, ... or am I better off with a full SQL Server install. ...
      (microsoft.public.dotnet.framework.adonet)
    • Re: Exception trying to import data from Excel .
      ... An attempt to install Microsoft SQL Server 2005 this week has not gone ... The connection type "EXCEL" specified for connection manager ... to create a connection manager for an unknown connection type. ...
      (microsoft.public.sqlserver.tools)