Create user.....

Hi.
i want to create a user which can communicate with the sql server 2000
through any third party application e.g VB, Java etc, but the user cannot
login dirctly on EM or query Analyzer.
ThankxxxMuhammad Bilal (MuhammadBilal@.discussions.microsoft.com) writes:
> i want to create a user which can communicate with the sql server 2000
> through any third party application e.g VB, Java etc, but the user cannot
> login dirctly on EM or query Analyzer.
That is not possible. But if the applicaiton relies on stored procedures,
all the user needs is EXEC permission on the procedures. If the application
uses embedded statements, the user will have to have full permissions,
unless the application uses application roles.
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx|||I suggest "googling" for the words "trusted subsystem". In a Trusted
Subsystem model, you create a service which performs all of the actions
on the database. This service (many times it's hosted in IIS) runs
under a normal account which has privileges to access the database, and
it is responsible for enforcing the security of your transactions.
But the real answer to your question is "you can't". There's nothing
special about SSIS, EM, QA, or even your VB/Java app. They all connect
and interact with SQL Server in very similar ways.
Muhammad Bilal wrote:
> Hi.
> i want to create a user which can communicate with the sql server 2000
> through any third party application e.g VB, Java etc, but the user cannot
> login dirctly on EM or query Analyzer.
> Thankxxx
>