Determine User Permissions for Table Obj (Select/Update/Insert/Delete)

[smedvid]

I have a need to review User permissions for a specific table to determine if I can enable UI buttons for Insert/Update/Delete... I have reviewed some T-SQL Call options online but they seem overly complex.

My desire is to pass in a User Name and Table Name to a function and see if they have Insert/Update/Delete or any combination then enable buttons on UI accordingly.

Example "EXEC SomeFX 'domain1\smed345','dbo.tbl_VVL_States'

All network users will be members of one or more DB Roles! If that helps. And, DB Roles will have object permissions for Select/Delete/Exec/etc...

This should be simple imho... or am I missing something?

Thanks In Advance!


Steve Medvid
IT Consultant & Web Master