Prevent user access through Query Analyzer etc.

kalin

Hi All !

I want to forbid users login to SQL Server with anything accept Navision Client.
I try to experimented with sp_$ndo$loginproc and database role but with no succcess. Any help?

Wojtek

ara3n

if they have just public role, they won't be able to do anything with other software.

kalin

ara3n wrote:

if they have just public role, they won't be able to do anything with other software.

Yes, but they would by able to do something with Navision data and skip all business logic implemented in NAV.

ara3n

with public role, you cannot do SELECT, UPDATE, DELETE statements, so they cannot view or modify any data.