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 |
|
muhiar
Starting Member
37 Posts |
 Posted - 2005-11-30 : 07:10:43
|
| hi all how can i get the password of the sa user?i have to include the password with bcp and it has to be hard coded what if the password changed ,i have to go to the trigger and change it i want function or global variable to get it like the user or is there any other way to get other it??????? |
|
|
AndrewMurphy
Master Smack Fu Yak Hacker
2916 Posts |
Posted - 2005-11-30 : 07:49:09
|
| how can i get the password of the sa user?a)...ask the owner of that id to release the password to you.orb)...ask the DBA to issue with a more appropriate userid for you to accomplish your action...SA is TOO powerful. |
 |
|
|
muhiar
Starting Member
37 Posts |
Posted - 2005-11-30 : 08:11:17
|
| THIS means that the password has always to static and never change or go through the entire triggers and change them |
|
|
|
AndrewMurphy
Master Smack Fu Yak Hacker
2916 Posts |
Posted - 2005-11-30 : 09:00:18
|
| Yup....There is that downside.But the massive upside is that nobody can programatically determine the SA password or anything else that is important. |
|
|
|
blindman
Master Smack Fu Yak Hacker
2365 Posts |
Posted - 2005-11-30 : 09:46:23
|
| Andrew's option "b" is what you need. Applications should NEVER EVER EVER EVER EVER use the SA password. What you are doing might get you fired in some IT shops.Ask for a dedicated login to be created for you, or use integrated security based upon the Windows login of the user running the application. |
|
|
|
|
|
|
sql server password