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 |
vishu_av
Yak Posting Veteran
69 Posts |
Posted - 2008-03-10 : 02:33:54
|
Hi All,i am the SA user for the SQL server.Now can i set the password at the Database level?I donot want create USERS and grant them permissions I wish to explicitly create password for a database in my server.Thanks in advance. |
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-03-10 : 12:00:29
|
Why you wanna create password for database? Nor sure i understood your question. Please elaborate. |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-03-10 : 22:30:41
|
Take look at application role. |
|
|
vishu_av
Yak Posting Veteran
69 Posts |
Posted - 2008-03-11 : 02:42:07
|
The situation is that, Whoever access the SQL server uses same SA username and password and that we donot have users created for our server here.. Sounds absurd but thats how it is here in our work place.Therefore was just curious to know if a SA can set password at DB level. |
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2008-03-11 : 08:39:56
|
Not quite sure what you're asking , are you asking if the "sa" can have more than 1 password , and each password would give different access to different dbs?Jack Vamvas--------------------Search IT jobs from multiple sources- http://www.ITjobfeed.com |
|
|
elancaster
A very urgent SQL Yakette
1208 Posts |
Posted - 2008-03-11 : 09:09:28
|
i think i see what you mean...so everyone logs on as SA, you then want to 'password protect' a database in the same way as you would a spreadsheet for example..? NO, you can'tEm |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-03-11 : 23:23:42
|
Create sql login for each user, never let them use sa. |
|
|
vishu_av
Yak Posting Veteran
69 Posts |
Posted - 2008-03-12 : 02:16:52
|
Elancaster got that right..I guess i need to create users and have no choice.. :-(Thanks to all for your valuable advice. |
|
|
|
|
|