Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 360
  • Last Modified:

security related tables in SQL Server

I am trying to document some useful security related tables in SQL Server (2000, 2005 and 2008) that would be of interest to auditors to create an account with read only access permissions to query those. Can you detail which are the main security related tables/views in SQL Server (so perhaps those with account information, permission information, physical file information (i.e. where is the database), etc.
0
pma111
Asked:
pma111
1 Solution
 
ralmadaCommented:
I don't think you need to document those tables. They are already documented. An auditor might be interested in reviewing these ones:

http://msdn.microsoft.com/en-us/library/ms178542.aspx

But they will not look into tables only, you can have a better understading on SQL security by reviewing the following:

http://msdn.microsoft.com/en-us/library/bb283235.aspx
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now