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?
Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.
Let's review the features of new SQL Server 2012 (Denali CTP3). It listed as below:
PERCENT_RANK() function will returns the percentage value of rank of the values among its group.
PERCENT_RANK() function value always in be…
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.