SQL Server: Permissions on table -

SQL Server 2008:

What types of roles can I determine for what kind of permissions

You can get all permissions. Filter in the database and filter for your table:

  Select sys.database_permissions from pay permissions, state, pr.name Sys.database_principals pay per pay.grantee_principal_id = pr.principal_id where the square is equal to 1 and pe.major_id = object_id ('& lt; table_name & gt;') and pe.minor_id = 0;  

In addition to this you have been created in role permissions (db_owner, db_datareader, db_datawriter etc).