login security question

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: Sunanda (Sunny_at_discussions.microsoft.com)
Date: 06/25/04 

Date: Fri, 25 Jun 2004 11:15:01 -0700

Hi,

I have an application which connects to the SQL server. We have several users logging into this application. All of their user-id, passwords are validated and converted to an owner profile, which is then used throughout the application.

My problem is, this owner profile should be prevented from accessing the database directly using Enterprise Manager or Query Analyser. The database should be accessible only from the application for this owner/global profile.

How do I go about achieving this. The application was set up like this by a person long time back who is not with us anymore. Also, I do not know SQL Server Administration. So, please detail out what information I have to look up and what steps I will have to follow.

Thank you in advance.
Sunny