SQL Error regarding permissions - other user has identical

katie_at_creative

Hello all,

We have someone getting a SQL Error regarding permissions, another user has identical permissions in SQL and in NAV but only 1 user is getting this.

The following SQL server error or errors occurred when accessing the XXXXXX table 1088, "42000",[Microsoft][ODBC SQL Server Driver][Sql Server] Cannot find the object "Databasename.dbo.companyname$table name" because it does not exist or you do not have permissions.

SQL:
SET IDENTITY_INSERT "Databasename"."dbo"."companyname$table name" ON

They are using 2009 sp1. I have synchronised. I have deleted the user in SQL and in NAV and recreated and no joy. They have SUPER role.

Any ideas?

Many thanks,
Katie

bbrown

I will gaurentee the users do not have identical SQL permissions. The "Set Identity Insert" is only valid to someone that is DB_Owner or better. This issue is caused by improper use of auto-increment property. Search this forum on "SET IDENTITY INSERT" and you will find your answers.

bbrown

Also what SQL permissions are assigned? A normal NAV user doesn't require any special SQL permissions beyond the default of membership in Public role.