What do you mean by ...count a role in a table..."?
Users are associated with roles, and roles have associated permissions, and permissions are associated with database objects (e.g. tables).
You can list the permissions for a given database object in a variety of ways; See the INFORMATION_SCHEMA.COLUMN_PRIVILEGES view in BOL. Also, there are several system stored procedures such as sp_helprotect and sp_helprole which may get you started.
Jeff Mason
Custom Apps, Inc.
www.custom-apps.com
Role Count
