Solved

Security Report

Posted on 2001-09-07
1
222 Views
Last Modified: 2012-05-04
We have to generate a report of who has what access to what tables in a database that contains confidential information.  I have go it to the point of seeing what roles can see what obects by using sysobjects, sysusers and syspermissions.  Now can I get it to show what access each of the roles have to the tables.   I see the binary columns (seladd,selmod) in the syspermission tables but I can not select them because they just return null.   Is there some way that I can get what I need out of SQL server?
0
Comment
Question by:curtis591
1 Comment
 
LVL 3

Accepted Solution

by:
mathavra earned 50 total points
Comment Utility
Have you tried sp_helprotect store procedure. It gives necessary output for the whole database if you do not pass any "objectname" or "username".

If you want to find out how to convert the binary values from seladd, selmod column, look at the code in sp_helprotect procedure code. It uses a table called "spt_values" in master to convert them.

Hope this helps.

Mathav
0

Featured Post

Free Gift Card with Acronis Backup Purchase!

Backup any data in any location: local and remote systems, physical and virtual servers, private and public clouds, Macs and PCs, tablets and mobile devices, & more! For limited time only, buy any Acronis backup products and get a FREE Amazon/Best Buy gift card worth up to $200!

Join & Write a Comment

Introduced in Microsoft SQL Server 2005, the Copy Database Wizard (http://msdn.microsoft.com/en-us/library/ms188664.aspx) is useful in copying databases and associated objects between SQL instances; therefore, it is a good migration and upgrade tool…
Nowadays, some of developer are too much worried about data. Who is using data, who is updating it etc. etc. Because, data is more costlier in term of money and information. So security of data is focusing concern in days. Lets' understand the Au…
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

771 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now