Login

Is it poosible to create a user in SQL Server 2000 who has the rights to
update, delete & insert in a database. The user can login in to tha databas
e
through a third party application i.e VB etc but cannot log directly on the
enterprise manager and query analyzer console.
ThankxYes,
S2K Database has Role and User.
You can create users and roles.
You can use built-in Database Role such as db_datawriter.
"Muhammad Bilal"?? ??? ??:

> Is it poosible to create a user in SQL Server 2000 who has the rights to
> update, delete & insert in a database. The user can login in to tha datab
ase
> through a third party application i.e VB etc but cannot log directly on th
e
> enterprise manager and query analyzer console.
> Thankx