password

• peloke

  SSC-Addicted

  Points: 409

  More actions

  September 27, 2002 at 12:13 pm

  #75964

  Is there any way to use a stored procedure to grab the username and password of the current user? We are planning to use datajunction as a tool for one of our products and before dj can access the db, we need to send it the current users username and password. Currently we can't send this info to dj directly so we will need to grab it, somehow write it to a text file, let dj grab it then delete the text file. Any ideas?

  Thanks,

  Eddie

• Prakash Heda

  SSCertifiable

  Points: 5539

  More actions

  September 28, 2002 at 2:37 am

  #437433

  select user_name() will give you username and other details should be given by ur application only no way to capture password

  Prakash

  Prakash Heda
  Lead DBA Team - www.sqlfeatures.com
  Video sessions on Performance Tuning and SQL 2012 HA