Login Access

I want to give a login the ability to see all database objects, insert and
and delete data, run stored procedures, and execute objects within a specifi
c
database. I do not want them to create or delete any database objects or
adjust security. How do I accomplish that by using the database roles?
>I want to give a login the ability to see all database objects, insert and
> and delete data, run stored procedures, and execute objects within a
> specific
> database. I do not want them to create or delete any database objects or
> adjust security. How do I accomplish that by using the database roles?
With a user-defined role. There is no predefined role for executing
procedures. Check the permissions of the fixed db oles in BOL at
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/a08108a3-f1fb-43ac-a264-3f2f
9749db5d.htm.
Dejan Sarka
http://www.solidqualitylearning.com/blogs/

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