January 16, 2009 at 1:28 pm
Msg 229, Level 14, State 5, Line 1
The INSERT permission was denied on the object 'ProdRev', database 'Revenue', schema 'dbo'.
I have checked all the permissions on the data,server and table, the user has reader/writer and also ddl_admin. but still the user is getting this error. is there any way to troubleshoot.
thanks
January 16, 2009 at 8:55 pm
Do you mean the user is a member of the db_datawriter role? Being a member of db_datareader and db_ddladmin in this instance is irrelevant. Neither give access to INSERT into a table.
What happens if you give explicit INSERT rights to the user? Same error?
K. Brian Kelley
@kbriankelley
January 18, 2009 at 7:19 am
Check if the user belongs to a group that has deny permissions on insert to this specific table. In case of such a conflict, the deny takes precedence over the grant.
Adi
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
January 18, 2009 at 9:07 am
db_datawriter would give them insert (and update/delete) permissions. Check all the groups, look for DENY as ADI mentioned, and let us know which roles the user is a member of.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply