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

DNK85

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

DNK85

Have a one help me for this issue?

Slawek_Guzek

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

DNK85

Hi Slawek Guzek,

Thanks so much for your answer.

Regards,