Re: Permissions WTF

From: Jasper Smith (jasper_smith9_at_hotmail.com)
Date: 11/16/05 

Date: Tue, 15 Nov 2005 23:13:03 -0000

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 ?
>
>

Relevant Pages

  • Re: Query on SQL Server 2000 Linked Table Doesnt Provide Correct Results
    ... You may be able to use Lenin a calculated query field to determine if the count of characters is not what you expect. ... I have some backend tables in a SQL Server 2000 Database linked into ... User daemon value rlogin is true ... User bin value login is true ...
    (microsoft.public.access.queries)
  • Re: CONTAINS performance
    ... That said, and with the query plan, I can start to give you more ... relational join in the context of the free-text optimization, ... SQL Server tables. ...
    (microsoft.public.sqlserver.fulltext)
  • Re: Obtaining Window login name from a trigger
    ... > this when an application uses a single service account is to use SET ... > Jasper Smith (SQL Server MVP) ... > login account. ...
    (microsoft.public.sqlserver.server)
  • Re: Indexing Service, Openquery and sp_executesql
    ... SQL Server version and sp are you running? ... > data from the indexing service catalog when pasted into ... > query analyzer, but failed when put against sp_executesql ... I would choose Microsoft Indexing ...
    (microsoft.public.sqlserver.fulltext)
  • Re: Problem using Access or Query Designer to run queries in SQL Serve
    ... >or Query Designer within Enterprise Manager, it works and I get data back. ... >ODBC Call Failed [ODBC SQL Server Driver] Timeout Expirederror in Access ... >[ODBC SQL Server Driver] Timeout Expired ...
    (microsoft.public.sqlserver.odbc)