Re: problems sp_adduser

From: Vishal Parkar (vgparkar_at_hotmail.com)
Date: 05/27/03

  • Next message: Usman: "Re: powerfull user" 
    Date: Mon, 26 May 2003 18:42:47 -0600

    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.
  • Next message: Usman: "Re: powerfull user"

    Relevant Pages

    • 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)
    • Re: Enumerating Domain Members
      ... > was under the impression that the BDC had the members from ... > What I need is to enumerate the domain members, ... Since I have to execute these functions on the ... >>> question on how I could go against a BDC, ...
      (microsoft.public.security)