Re: sp_setapprole

From: Hal Berenson (haroldb_at_truemountainconsulting.com)
Date: 04/26/03 

Date: Fri, 25 Apr 2003 16:54:41 -0700

Let me be more complete...

You can take a look at the SETUSER command, but its use is not recommended
(and it may not be supported in future versions of SQL Server). 

-- 
Hal Berenson
True Mountain Consulting
"A.M" <hate-spam@pam.com> wrote in message
news:eqyz4TzCDHA.2044@TK2MSFTNGP10.phx.gbl...
> 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
>
>
>

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: Creating Customer Web Portal
    ... Roles and Profiles system that integrates with the database ... which a stored procedure builds for us. ... I want a simple login page with username and password. ...
    (microsoft.public.frontpage.addins)