How to execute SP_ADDUSER without DBO Priv.

From: Joe Webber (joe.webber@snclavalin.com)
Date: 09/11/02 

From: "Joe Webber" <joe.webber@snclavalin.com>
Date: Wed, 11 Sep 2002 12:27:48 -0700

I have a situation where I have an application that
requires to add SQL users to an application database. The
only way to do this is to run the store proc sp_adduser.
The problem I have is that it requires dbo privileges. I
do NOT want the application user to log on with dbo rights.

Is there a way so that a normal user (without dbo rights)
can run sp_adduser? Maybe running another store proc or
function under the dbo profile?

TIA,
Joe

Relevant Pages

  • Stopping logins making schema changes
    ... We have a server that contains one 20Gb database and, unfortunately, the ... application that connects to it has to have DBO rights or no rights at ... they've started adding DTS packages to the server. ...
    (microsoft.public.sqlserver.security)
  • Re: Windows Authentication
    ... Can you try the below from query Anlayzer: ... use <dbname> ... sp_addrolemember 'db_owner','dbusername' -- THis is database wide role ... > I would like to give a user dbo rights to a few ...
    (microsoft.public.sqlserver.security)
  • Re: Network Admins vs. Sql Progammers
    ... Normally they just need dbo rights on the database, if ysou want them ... HTH, Jens Suessmeyer. ...
    (microsoft.public.sqlserver)
  • Multiple Database name query
    ... I need to generate a script to return the database name for all databases ... the current user has dbo rights? ... I am tryint to user a select statement ...
    (microsoft.public.sqlserver.programming)