Re: xp_logininfo not working for some types of users

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Steve Z (szlamany_at_antarescomputing_no_spam.com)
Date: 06/04/04 

Date: Thu, 3 Jun 2004 19:01:06 -0700

IS_MEMBER runs for the current user - right?

We are looking to take a DOMAIN\USERNAME and see if that entity has rights to a database - not a server, but a particular database.

They have those rights basically two ways - by the specific username or some Windows Group.

We have 1000's of users across a WAN - when the admin folks want to add a user to our app, our user/role form allows them to enter "application specific roles" - not stored in the DATABASE. We want to show the DBA at this moment that they forgot to give this user access to the DATABASE - so that training doesn't fail for this person.

Relevant Pages

  • Re: Error code = 4060
    ... divisional portals are running under a different app pool and identity than ... the corporate portal, and the identity of this pool, while having dbo rights ... portal's content database. ...
    (microsoft.public.sharepoint.portalserver.development)
  • Re: db_denydatawriter
    ... perhaps this also gives read write access on the database to this user? ... Resrictive permissions overrides in its own level. ... However, if she has sysadmin right, then she'll be able to modify that data. ... Is it possible she has some admin rights which override DenyWriter (though ...
    (microsoft.public.sqlserver.security)
  • Re: Complete Neophyte Question(s)
    ... No you cannot remove a login from the 'public' role. ... For rights to _use_ objects then the appropriate rights need to be granted ... GRANT SELECT ON dbo.Orders TO OrderViewers ... for a database that is supposed to be secured it is a bad idea ...
    (microsoft.public.sqlserver.security)
  • Re: SUUNTO Vyper PC i/f
    ... username and password. ... to enter the database password. ... I gained access to the data in Suunto v2 using it - but it will NOT allow ... have the rights to the program the DATA is MINE!! ...
    (uk.rec.scuba)
  • Re: Attach database became readonly
    ... This posting is provided "AS IS" with no warranties, and confers no rights. ... Use of included script samples are subject to the terms specified at ... attached database behave as normal (i.e. it on longer is readonly ...
    (microsoft.public.sqlserver.setup)