Debugging table permissions for a windows user We have a SQL Server 2008 Database. 

I created a few Windows users, added them to a specific database, and granted them read write access with the scripts below:

CREATE LOGIN [PRUDENTIAL\X208476] FROM WINDOWS 
    WITH DEFAULT_DATABASE=[master], DEFAULT_LANGUAGE=[us_english];

Use client
GO
CREATE USER [PRUDENTIAL\X208476] WITH DEFAULT_SCHEMA=dbo
GO
exec sp_addrolemember db_datareader, [PRUDENTIAL\X208476]
GO
exec sp_addrolemember db_datawriter, [PRUDENTIAL\X208476]
GO


They run a basic insert command as follows and receive the error shown below:

INSERT INTO [client].[dbo].[admin_user_role]
           ([user_id]
           ,[role_id]
           ,[last_acty_oper_id]
           ,[last_acty_dtm])
     VALUES
           ('X208480'
           ,'ADMIN'
           ,'x163798'        
           ,'2017-04-06 11:12:19.597')

Msg 229, Level 14, State 5, Line 1
The insert permission was denied on object ‘admin_user_role’, database ‘client’, schema ‘dbo’.


I tested this with another colleague of mine and he has no issue inserting into the table.

What other check/debugging can I do to resolve this issue?
Please run this code to find out if you have a deny on that user under the column state_desc.

SELECT permission_name, 
   state_desc, 
   type_desc, 
   U.NAME, 
   Object_name(major_id) 
FROM   sys.database_permissions P 
   JOIN sys.tables T 
     ON P.major_id = T.object_id 
   JOIN sysusers U 
     ON U.uid = P.grantee_principal_id