Granting rights
Database
1
Posts
1
Posters
0
Views
1
Watching
-
i am using SQL 2000 server. i have created one user . i want that this user have following rights:- Select,Insert,Update,Delete on Tables. so i gave the user as DDLAdmin,Read acess and Write Excess. this is ok with my tables part. but for Stored Procedure i got a problem. I want that my user can execute and modify the Stored Procedure. For the execution part i ran Grant exec on to . but please tell me How should i give the user rights to modify the procedure??? I don't want to make user as DB_Owner. Kindly suggest any solution. Thanks in Advance.