Re: Permissions WTF

From: David J. Cartwright (davidcartwright_at_hotmail.com)
Date: 11/16/05

  • Next message: Gary D. Rezek: "Could not obtain information" 
    Date: Wed, 16 Nov 2005 09:09:43 -0500

    Thanks for reply, but it was my stupidity....i had been logged in as the
    user when i had created the user databases....then forgot it was a member of
    the group used to create the login.....should have realized it when it said
    i was member of db_owner and not srv role sysadmin...but i am getting slow
    at my old age.

    "Jasper Smith" <jasper_smith9@hotmail.com> wrote in message
    news:upEiioj6FHA.476@TK2MSFTNGP15.phx.gbl...
    > You are getting in with sysadmin priviliges, possibly by membership of
    > another group. What does the following query return for your windows
    > account?
    >
    > exec master..xp_logininfo 'DOMAIN\username'
    >
    > --
    > HTH
    >
    > Jasper Smith (SQL Server MVP)
    > http://www.sqldbatips.com
    > I support PASS - the definitive, global
    > community for SQL Server professionals -
    > http://www.sqlpass.org
    >
    > "David J. Cartwright" <davidcartwright@hotmail.com> wrote in message
    > news:uNI5pih6FHA.3684@TK2MSFTNGP12.phx.gbl...
    >>I have a intigrated log using a local group
    >> the login does not have explicit access to any db's and no server roles
    >> when i log on with query analyzer i can access any data (even though not
    >> a server admin or anything else)
    >> when i remove login....can log (as it should be)
    >> why does this login have full access to all db's ?
    >>
    >>
    >
    >

  • Next message: Gary D. Rezek: "Could not obtain information"

    Relevant Pages

    • 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: cannot acees two databases as owner
      ... You are going to be able to login to your SQL Server as a sysadmin as long as you have Builtin\Administrators Login exists Otherwise, it does not matter you are a member of the Administrators group on your Windows or not... ... You need to be a member of the sysadmin fixed server role on SQL Server to be able to manage it as you wish. ... Well, if you do not know any other Login's password which is a member of the sysadmin fixed server role or if there is no any other Login which is a member of the sysadmin and you can login to your SQL Server with, then it means you locked yourself out of your SQL Server box. ...
      (microsoft.public.sqlserver.setup)
    • 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: 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: System Administrator Implied Permissions
      ... member of the dbo group and you are automatically given ... Now, given this, why does SQL Server ... Much Thanks Dan. ...
      (microsoft.public.sqlserver.security)