MS SQL Server 2000

mohsen · #1 (**permalink**) 02-17-2008, 09:56 AM

I want to create a database and password protect it so that it can only be accessed through a program. How would I go about making such a database in MS SQL Server 2000?

**WingedPanther** · #2 (**permalink**) 02-18-2008, 11:56 AM

You can restrict access to the database to certain users. I'm not sure if that's what you had in mind, however.

mohsen · #3 (**permalink**) 02-18-2008, 01:23 PM

Ummm, I only want to have 1 user, and that user should only be able to login using a password

**WingedPanther** · #4 (**permalink**) 02-20-2008, 11:16 AM

So you would set a password for a user in the database manager. The user will always have to provide the password to access the database. Then associate that user with the database in question.

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Change method to send sql server sproc XML	hoser2001	Database & Database Programming	0	07-17-2007 09:35 AM
How do I centralize sql server database	hoser2001	Database & Database Programming	3	07-13-2007 01:07 PM
Accessing Databases without SQL Server or FP Extensions	ashleysmithd	Database & Database Programming	2	07-10-2007 01:47 PM
Some help with creating an XML document with SQL server 2000	hoser2001	JavaScript and CSS	2	08-24-2006 07:38 PM
Installing SQL server on Windows XP 64 bit	roger	Database & Database Programming	1	05-23-2006 10:13 AM

Xav	........	164.00000
dargueta	........	128.00000
John	........	127.00000
gaylo565	........	18.00000
XaNaX	........	15.00000
Johnnyboy	........	3.00000
navghost	........	1.00000

CodeCall

Contest Stats

Sponsors

Ads

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)