If not, then try this

SELECT dp.grantee_principal_id,p.name AS UName

,dp.permission_name,c.name

,OBJECT_NAME(o.object_id) AS TabName

FROM sys.database_permissions dp

INNER JOIN Sys.objects O

ON dp.major_id = o.object_id

INNER JOIN sys.columns C

ON c.object_id = O.object_id

AND c.column_id = dp.minor_id

INNER JOIN sys.database_principals P

ON...

See if this helps.

http://jasonbrimhall.info/2010/03/19/security-audit/

When you are viewing the data, how are you viewing it (e.g. what is that you are doing to see the ?'s)?

Ninja's_RGR'us (9/15/2011)

---

SQLRNNR (9/15/2011)

---

Steve Jones - SSC Editor (9/15/2011)

---

Please let's not have quotes of every post that counts down from 95, 94, 93.

I'm going out of town for a few days....

Steve Jones - SSC Editor (9/15/2011)

---

Please let's not have quotes of every post that counts down from 95, 94, 93.

I'm going out of town for a few days. I'm hoping...

Thanks for putting this article together.

Ummm - 96

You can try the upgrade of the browser - looks like it may be a memory leak in IE if FF is returning reasonably quickly.

I would just use a table then.

Also, since the fields vary depending on parameter - you should consider either hiding fields depending on parameter value or using multiple reports to...

Just saying that we only need 98 more posts for 30,000

The Stand

Well, that depends on your requirements. Do you just want to display the information? Or do you want to have expandable groupings?

Stuart Davies (9/15/2011)

---

bitbucket-25253 (9/15/2011)

---

Following quote, high lighting added by this poster

Stuart Davies (9/15/2011)

---

Thanks for the question. I've only submitted a couple over the years and know how quick others are...

More important than the table design is that when there is free food/drink people will come 😀

Thanks for the question.