Re: Permissions WTF

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

Date: Tue, 15 Nov 2005 14:28:14 -0500

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 ?

"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

  • I missed one "little" thing - Thanks!!!!
    ... I had done everything your script does through EM. ... Added ASPNET as a login with no server roles but database access to ...
    (microsoft.public.sqlserver.security)
  • Re: Permissions of Logins
    ... You aksed if the login is associated to a database user. ... >> no server roles. ...
    (microsoft.public.sqlserver.msde)
  • Re: Account Dropped but Public Role still shows account?
    ... I'm not sure where you are looking at this - server roles or ... A user can have another name in a database - ... >> user then drop the login if needed. ... >> the error number and error message you get when you try to ...
    (microsoft.public.sqlserver.security)
  • 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)
  • Permissions WTF
    ... 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)