Re: Create user.....

Muhammad Bilal (MuhammadBilal@xxxxxxxxxxxxxxxxxxxxxxxxx) 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@xxxxxxxxxxxxx

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
.

Relevant Pages

  • Re: Help with SQL 2005 and Sourcesafe 6
    ... That doesn't seem to be the case with stored procedures. ... compile that latest version to be table to use it. ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... Books Online for SQL Server 2005 at ...
    (microsoft.public.sqlserver.tools)
  • Re: nested stored procedures and returning lots of rows
    ... I initially thought of using nested stored procedures and returning ... proc then the called stored procs can't see it ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... Books Online for SQL Server 2005 at ...
    (comp.databases.ms-sqlserver)
  • Re: Error msg
    ... > I have corrected my stored procedures with what you said. ... In an interface like ADO you would iterate over ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... Books Online for SQL Server 2005 at ...
    (microsoft.public.data.oledb)
  • Re: Error msg
    ... > The stored procedures looks like this: ... > // update record table here ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... Books Online for SQL Server 2005 at ...
    (microsoft.public.data.oledb)
  • Re: Select query help+primary key
    ... While SELECT * is handy when running ad hoc-queries, ... Finding which stored procedures is simple, ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... Books Online for SQL Server 2005 at ...
    (comp.databases.ms-sqlserver)