Permissions

Does anyone have a script that can be used to return all users granted
permission to a cretain table, it would be greatly appreciated!
TIA, JordanSELECT DISTINCT GRANTEE FROM INFORMATION_SCHEMA.TABLE_PRIVILEGES
WHERE TABLE_NAME = 'your_table'
There more information in TABLE_PRIVILEGES, as well as COLUMN_PRIVILEGES
that might be useful.
Jacco Schalkwijk
SQL Server MVP
"JMNUSS" <JMNUSS@.discussions.microsoft.com> wrote in message
news:2DF7F368-A8FC-4454-BCAC-E71FC002B924@.microsoft.com...
> Does anyone have a script that can be used to return all users granted
> permission to a cretain table, it would be greatly appreciated!
> TIA, Jordan|||Also look up the system procedure, sp_helprotect in SQL Server Books Online.
Anith