Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
shanmugaraj
Posting Yak Master
219 Posts |
 Posted - 2006-02-24 : 09:36:26
|
| hi,i am new to programming...when i do a project in MS Access , i have the option of password , which doesnot allows unautorized users to see the database design..But in SQL server 2000 , is there any option to set password for the database...???Thanks in advance.... |
|
|
AndrewMurphy
Master Smack Fu Yak Hacker
2916 Posts |
Posted - 2006-02-24 : 10:28:16
|
| not as such. you configure the server to only access to the databse to specific server userid's/roles....and you then attach passwords to the userid's. |
 |
|
|
AndrewMurphy
Master Smack Fu Yak Hacker
2916 Posts |
Posted - 2006-02-27 : 04:18:08
|
| Add a database.Add a user/role to the SQL Server.(If you go down the role route, you then add a user to the role)Give the user a password.Grant the user/role access (update/readonly/executeonly depending on your needs) to the Server.Practice using EM...and then when familiar with the concept and how the above fits together, lookup the relevent "System SP's" so that you can do it without EM.....EM is alright, but to learn and improve you really need to get to grips with executing things via raw T-SQL. |
|
|
|
activecrypt
Posting Yak Master
165 Posts |
|
|
|
|
|
database password