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 Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

SQL SERVER 2000 adding a new user

Status
Not open for further replies.

tempo1

Programmer
Feb 20, 2007
118
Hi everyone,
My question is as simple as that:
I want to add a new user for a particular database. That user should be working freely on that particular database (createing db, editing tables, removing tables) but he shouldn't have access to any other database and shouldn't have maste's permissions.
Could anyone give me the correct instructions ?
Thanks
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top