sp_setapprole

From: A.M (hate-spam_at_pam.com)
Date: 04/25/03

  • Next message: Steve Anthony: "what account does the server use to run sp" 
    Date: Fri, 25 Apr 2003 09:14:21 -0500

    Hi,
    I am trying to use sp_setapprole inside a stored procedure, SQLServer says:

    "Application roles can only be activated at the ad hoc level."

    I need to login to different usename inside the stored procedure and then
    encrypt the SP. How can i login as different user inside my stored
    procedure?

    Thanks,
    Ali

  • Next message: Steve Anthony: "what account does the server use to run sp"

    Relevant Pages

    • Re: [PHP] access to DB and security
      ... If i use this login + password to connect and perform some actions ... only execute some stored procedure but can not administrate my DB. ... One is to switch to a host, perhaps a dedicated host, where you DO ... business process and authentication model looks like... ...
      (php.general)
    • Re: Limiting views on data in a table
      ... >returns the Windows login the user uses to connect to SQL Server. ... >use it in the WHERE clause of your single stored procedure for everybody to ... pass the login name as a parameter in the stored procedure). ...
      (microsoft.public.sqlserver.security)
    • Re: Drop Merge Pull Subscription at Publisher?
      ... when a login who is in the PAL has the permission ... login call sp_dropmergesubscription also on the Publisher. ... > information of where this stored procedure should be run at and there will ...
      (microsoft.public.sqlserver.replication)
    • Re: SQL Connection help needed
      ... Have your DB Admin give your NT login access to the stored procedure ... Here is my current connection string that is using my own NT login: ... I have access to this database and the connection establishes fine. ...
      (microsoft.public.dotnet.languages.vb)
    • Re: sp_setapprole
      ... You can take a look at the SETUSER command, but its use is not recommended ... > I am trying to use sp_setapprole inside a stored procedure, SQLServer ... How can i login as different user inside my stored ...
      (microsoft.public.sqlserver.security)