User Settings

I want to define a set of user permissions for a SQL Server 2000 database giving remote users read-only access to all objects but with the ability to create new queries. When I check the db_owner role in the Enterprise Manager, users can create their own queries but can also delete existing queries. Is there a way I can give users who access the site over the internet the ability to create but not delete queries? Thanks for any suggestions.

Ken McLean

 

I am not sure if I understand your problem correctly, do you mean stored procedure when you talked about queries?

 

I was referring to any query object -- views, stored procedures, functions, etc . I would like remote users to be able to create their own but not delete those that are alread saved in the database.


Ken McLean