Login/User/Role Audits

From: yellowbug (anonymous_at_discussions.microsoft.com)
Date: 02/06/04 

Date: Fri, 6 Feb 2004 14:56:05 -0800

Hi.. I currently moved an assortment of 2 groups of databases off 2 old servers onto 1 new server, and was looking for a method of auditing logins/users/roles for a few thousand logins.

Does anyone know an easy way to check to make sure all of the logins have permissions to all of the databases and are members of a certain role?

Thanks!

Relevant Pages

  • Re: object level permissions being lost when migrating
    ... I am talking about SQL Logins, ... can go to the object and see that user X has permissions XYZ on that object, ... I then restored the databases and re-synched the users via the ...
    (microsoft.public.sqlserver.security)
  • Re: object level permissions being lost when migrating
    ... I meant when you checked on the permissions did you run a query or use the gui to see them? ... If you use a query make sure it references the new tables / views and not the 2000 ones. ... > I first transferred the logins from the 2000 server to the 2005 server> via ... > databases that reside on the SQL 2000 server (which I still have and> can ...
    (microsoft.public.sqlserver.security)
  • Re: Application Role
    ... One additional point--application roles are also members of the public ... database role, so they will have any permissions granted to public. ... >have created logins ...
    (microsoft.public.sqlserver.security)
  • Permissions for the predefined database roles
    ... tables in all databases? ... I've assigned a couple of logins to the db_datareader role, ... that no permissions have been assigned to that user. ... Have I misunderstood something...or am I doing something wrong? ...
    (microsoft.public.sqlserver.security)
  • [UNIX] Privilege Escalation Vulnerability on phpBB
    ... permissions), so although admin rights are needed to view the page, anyone ... Goto the board you wish to change the permissions for in the normal way ... Find the base directory location of the board for the script, ... This bulletin is sent to members of the SecuriTeam mailing list. ...
    (Securiteam)