SQL Error regarding permissions - other user has identical

katie_at_creative
katie_at_creative Member Posts: 42
edited 2012-01-05 in NAV Three Tier
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

Comments

  • bbrown
    bbrown Member Posts: 3,268
    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.
    There are no bugs - only undocumented features.
  • bbrown
    bbrown Member Posts: 3,268
    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.
    There are no bugs - only undocumented features.

Categories