Permissions WTF

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

Date: Tue, 15 Nov 2005 14:13:24 -0500

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 ?

Relevant Pages

  • Re: DB connection problem in attemp to load DataGrid from SQLServer DB
    ... Added ASPNET as a login with no server roles but database access to ... SQL login named 'ASPNET'? ...
    (microsoft.public.sqlserver.security)
  • Help(!) with Server Roles
    ... I have me a brand new failover cluster (2005 SP2). ... However when I attempt to change the Server Roles for any Login, the check boxes are not displayed in Management Studio! ...
    (microsoft.public.sqlserver.tools)
  • Help(!) with Server Roles
    ... I have me a brand new failover cluster (2005 SP2). ... However when I attempt to change the Server Roles for any Login, the check boxes are not displayed in Management Studio! ...
    (microsoft.public.sqlserver.clustering)
  • Re: Permissions WTF
    ... When i add the login and run IS_MEMBER and USER it says i am dbo of a user ... database that i did not give access to what is going on? ... >I have a intigrated log using a local group ... > the login does not have explicit access to any db's and no server roles ...
    (microsoft.public.sqlserver.security)
  • Re: Newbie: guest account with SSPI
    ... you need to add a SQL login for MYDOMAIN/johnd ... However, may I suggest you create a Local Group on the SQL Box, add domain ... > 1) Is this a Windows Authentication problem or an SQL server problem? ...
    (microsoft.public.sqlserver.server)
Quantcast