Re: SQL Login

From: Dejan Sarka (dejan_please_reply_to_newsgroups.sarka_at_avtenta.si)
Date: 08/28/03

  • Next message: Sanka: "Re: SQL Login" 
    Date: Thu, 28 Aug 2003 11:01:18 +0200

    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
  • Next message: Sanka: "Re: SQL Login"

    Relevant Pages

    • Re: SQL Login
      ... The sa login account is a member of that role as well. ... Dejan Sarka, SQL Server MVP ... > But how do we add the User X to the sysadmin / ...
      (microsoft.public.sqlserver.security)
    • Re: Other way of Changing Password if does not have Server Role
      ... A user can change his password without being a member of the sysadmin role. ... You just have to login as the user and then omit the 3rd parameter ... Dejan Sarka, SQL Server MVP ...
      (microsoft.public.sqlserver.security)
    • Re: Unexpected Login Screen When Accessing SQL Data Via .NET Intra
      ... >> data and the SQL Server is on the same server. ... >> My problem is that one user has started getting a login popup ... >> right in via Windows Authentication like everyone else and like they ...
      (microsoft.public.sqlserver.connect)
    • Re: cannot acees two databases as owner
      ... it does not matter you are a member of the ... the sysadmin fixed server role or if there is no any other Login which is ... group if it's a domain) and you can login to your SQL Server with, ...
      (microsoft.public.sqlserver.setup)
    • Re: Database security design with ASP.net and form-based authentication
      ... Since you already have forms-based security, why not use a single SQL login ... for all database access? ... data entry, guest/view only, admin, report viewer. ... so I'm using SQL Server authentication. ...
      (microsoft.public.sqlserver.security)