Re: problems sp_adduser

From: Carlos A. (carlos.augusto_at_terra.com.co)
Date: 05/27/03 

Date: Tue, 27 May 2003 05:31:30 -0700

Thank you Vishal

Carlos A.

>-----Original Message-----
>sp_addlogin:
>Members of sysadmin and securityadmin server roles can
execute sp_addlogin
>and no one else.
>sp_addrolemember:
>Members of the sysadmin server role and the db_owner
fixed database role can
>execute sp_addrolemember to add a member to fixed
database roles. At the
>same time role owners can execute sp_addrolemember to add
a member to any
>SQL Server role they own. Members of the db_securityadmin
fixed database
>role can add users to any user-defined role.
>
>Run sp_grantdbaccess instead of sp_adduser. Only members
of the sysadmin
>fixed server role, the db_accessadmin and db_owner fixed
database roles can
>execute sp_grantdbaccess
>
>--
>--Vishal
>"carlos A." <carlos.augusto@terra.com.co> wrote in message
>news:2ab301c323d1$55522650$a101280a@phx.gbl...
>> Hi everybody.
>>
>> I have a user with permissions securityadmin and dbo on
a
>> specific database
>>
>> What additional permissions this user must have to be
able
>> to execute sp_addlogin and sp_addrolemember?.
>> without being sysadmin.
>
>
>.
>

Relevant Pages

  • Re: sp_password
    ... Only members of the SysAdmin and SecurityAdmin roles can execute sp_password ...
    (microsoft.public.sqlserver.security)
  • Re: GUI for access 2002
    ... 1.I execute a command button that loads the form with data from a members ...
    (microsoft.public.access.gettingstarted)
  • Re: SP Permission Inheritance and Table Creation
    ... > a way that limits the user from actually mimicking the application ... role so that you can execute sp_rename. ... CREATE PROC usp_PubStatic_Maintenance ... sysadmin role members or the dbo can execute the procedure. ...
    (microsoft.public.sqlserver.security)
  • Re: processadmin role
    ... Members of Processadmin role can only kill a process. ... the processes running in SQL Server, the only management option they have is ... To view the history of job, DBA can assign the execute prev on ...
    (microsoft.public.sqlserver.server)
  • Re: Transactions in ADO.Net 2 strongly-typed datsets.
    ... you need to first execute ... GroupMembers, Updates on Group members, and wrap these up by calling Deletes ... specify the transaction property to all the IUD commands. ...
    (microsoft.public.dotnet.framework.adonet)