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.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Sql Password

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2003-07-01 : 07:35:34
R.Sankarasubramanian writes "Dear sir,
I want to get the sql server user name pwd in a stroed procedure where it is running
i got the server name by @@server name
i got the user name by @@system_user
how do i get the password for the current user"

robvolk
Most Valuable Yak

15732 Posts

Posted - 2003-07-01 : 07:40:12
You don't. Ever. If someone cannot supply the proper password, they cannot log in under that user name. There would be no purpose and no security in having a password that can be read by anyone.

Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2003-07-01 : 15:55:36
This cracks me up. I needed a good laugh today (dealing with SQL Mail configuration problems).

Tara
Go to Top of Page
   

- Advertisement -