Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

SQL server uer account permissions

Status
Not open for further replies.

learner45

Technical User
Jul 31, 2009
16
GB
Hi,

We are doing some update/maintenance work on our classic ASP site which is backed by SQL Server 2005. The person doing the work comes from outside the company and needs access to the DB server. I was wondering what type of account and permissions he should be given.

The requirements are:

1. Access restricted to only 1 database [INVENTORY]
2. No possibility of creating, modifying user accounts
3. No possibility of modifying, updating, deleting of tables and records
4. Possibility of modifying, creating stored procedures (however the permissible statements should not include commands reserved for DB Admin and Owner accounts).


Thanks a lot to all the helpful Gurus!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top