Force Unlock Permission Error

Comments

• Options

  matteo_montanari Member Posts: 189

  2013-11-22

  paramb wrote:

  One of my team member created a Nav database in Nav 2009 R2. I am a super user. But I cannot Force Unlock a table object. I get the generic error message: 'You do not have permission to modify the Table. Contact you system administrator to have your permissions changed'.
  
  Do I require any other permission in SQL Server side apart from Super user in NAV.
  
  Any help is really appreciated.

  
  Hi
  
  You need "Owner" role on your database.
  
  Bye
  
  Matteo

  Reno Sistemi Navision Developer

  0
• Options

  paramb Member Posts: 85

  2013-11-22

  Thanks for the reply.
  
  I have checked my Login Properties of the SQL Server and found that I have been given sysadmin role. Also I have setup db_Owner under Database role membership.
  
  But I continue to receive the same error message.

  0
• Options

  geordie Member Posts: 655

  2013-11-24

  Probably I'm wrong but it seems a license problem to me: are you and your colleague using the same license?

  * Daniele Rebussi * | * Rebu NAV Diary *

  0
• Options

  paramb Member Posts: 85

  2013-11-25

  Yes. License caused the issue. I have imported the latest license and ALL GOOD NOW!....
  
  Thank you very much.

  0