row level permissions

is there a simple procedure to run to find what the row level permissions are on each user?

thanks.

I am not clear with the requirement. There is no row level permission in sql server if its refering to Table rows. You can give table level permission or you can create views as per the conditions and give permission to views.

Madhu

|||I should clearify. I'm looing for table level permissions. I assume there is a simple procedure to run to find this information for each user.|||

Take a look at the INFORMATION_SCHEMA.TABLE_PRIVILEGES view. This might provide the detail you're looking for.

HTH!

|||

or you can use sp_helprotect /sys.database_permissions and fn_builtin_permissions to get the permission on objects.

Read about

SP_HELPROTECT/sys.database_permissions (sql server 2005) in BOL

Madhu