Grant deleted session to user - Navision 2009 R2 with SQL database

DNK85
DNK85 Member Posts: 7
in NAV/Navision Classic Client
Hi All,

I have migrated Native Database to SQL database for NAV system. Almost things work fine, but I have problem with user permission to delete user session when user license full. The user with super role can't delete the user session because do not have permission to kill session on SQL server. After searching from Google, I found the SQL command that allow user to kill session: "Alter any connection to <user>" and it worked fine. But I dont know is this the good way to grant this permission to user? What permission user have on SQL database and Navision with "Alter any connection" granted to?

Please give me the advise for this issue.

Regards,

NK

Answers

  • DNK85
    DNK85 Member Posts: 7
    Have a one help me for this issue?
  • Slawek_Guzek
    Slawek_Guzek Member Posts: 1,690
    Hi,

    Apart from that usually only the system / server administrators should have the ability to manage/kill user sessions it looks like you've done the correct thing.

    The "alter any connection" permission is the minimum permission necessary for a user to kill another session. It does not imply any other permissions as far as I know.

    Slawek

    Slawek Guzek
    Dynamics NAV, MS SQL Server, Wherescape RED;
    PRINCE2 Practitioner - License GR657010572SG
    GDPR Certified Data Protection Officer - PECB License DPCDPO1025070-2018-03
  • DNK85
    DNK85 Member Posts: 7
    Hi Slawek Guzek,

    Thanks so much for your answer.

    Regards,

Categories