Allocate quota to log-in

uto

I 've tried to search in the forum about killing the session, but I'm not found the forum which match my problem.

I have a little bit problem about Log-in process, that is I would like to allot the quota to logon the database by user department.

Whenever, user try to login , I would like to verify user department (let say it filled in user setup table) and allowed session. In case the logging user has exceed the quota, the program should pop-up the error message. By the way, the program will allow them to login when the connection is not exceed the quota.

Any idea? please suggest.

Thanks.

P.S. I use Navision4.0 SQL option

SteveO

You could try to use login scripts that are available when you use SQL.

There is a stored procedure called [sp_$ndo$loginproc] that can be called. Read the Developers Guide for more information.