Re: SQL Login

From: Sanka (loonysan_at_mailcity.com)
Date: 08/28/03 

Date: Thu, 28 Aug 2003 03:18:13 -0700

Hi,

But how do we add the User X to the sysadmin /
securityadmin role first.

Does the User X need to depend on the "SA" password or
some other sysadmin / securityadmin personnel for that.

Regards,
Sankaranarayanan M G

>-----Original Message-----
>To add a login, a user must be a member of the sysadmin
or securityadmin
>fixed server role. So, if the Windws account is a member
of some of those
>two roles, a user can add a login, otherwise not. Check
the "Adding a Member
>to a Predefined Role" topic in Books OnLine
>(mk:@MSITStore:C:\Program%20Files\Microsoft%20SQL%
20Server\80\Tools\Books\ad
>minsql.chm::/ad_security_6ndx.htm).
>
>--
>Dejan Sarka, SQL Server MVP
>FAQ from Neil & others at: http://www.sqlserverfaq.com
>Please reply only to the newsgroups.
>PASS - the definitive, global community
>for SQL Server professionals - http://www.sqlpass.org
>
>"Sanka" <loonysan@mailcity.com> wrote in message
>news:08ef01c36d36$80718250$a401280a@phx.gbl...
>> Hi,
>>
>> User X is a machine administartor in the SQL Server box.
>> By Default, when User X logs in the machine, he is not
>> able to access any of the DTS packages / access tables
>> present in the Databases.
>>
>> Guess the User X ID has to be added in the SQL Server as
>> well. Is it possible for User X to login in the machine
>> and add himself as the Administrator of the SQL Server
>> without knowing the "SA" Password or with no help from
the
>> other SQL Server Administrators.
>>
>> Regards,
>> Sanka

Relevant Pages

  • Re: sp_AddLogin
    ... not involve the obvious sysadmin and securityadmin. ... and only on a couple of databases ... >Columnist, SQL Server Professional ...
    (microsoft.public.sqlserver.security)
  • Re: securityadmin roles
    ... You should check out fixed server and fixed database roles in the BOL. ... SQL Server MVP ... So what is the purpose of this securityadmin role??? ... Can't a DBCreator create new logins to the database it creates? ...
    (microsoft.public.sqlserver.programming)
  • Re: permissions required for executing CDOSys stored procedures
    ... he is by default member of the sysadmin server ... role on the SQL Server database unless steps are taken to prevent that. ... sysadmin and who has not been granted specific execute permissions on the ... it is possible to GRANT EXECUTE ON sp_OACreate TO ...
    (microsoft.public.sqlserver.security)
  • Re: Sharepoint index problems in SQL Server.
    ... The Administrator account is a sysadmin and have all the access to all the ... > database is master and language US_English? ... >> I've set back the account localsystem for both SQL Server and Microsoft ...
    (microsoft.public.sqlserver.fulltext)
  • Re: Move or Setup of SQL Database toa Remote Server Fails
    ... as well as have SysAdmin privileges on the DB. ... Registered type 501ST MASTER for 501ST SCCM1DB\master ... Could not connect SQL Server 'master' db. ... The SCCM Primary Site Computer Account and the User account I am using ...
    (microsoft.public.sms.setup)