tags:

views:

27

answers:

1
Q: 

Fetching unix users from SQL Server

Hi,

We have some tables where we store some sensitive information. These tables have one extra column "ModifiedBy". Currently we insert the value for this column programmatically.

I am wondering if we have some way to get the current unix user into SQL Server. The idea is to auto-populate the user name/id into that column with the use of triggers.

Thanks Nayn

+1  A: 

You don't mention the language or situation, so an answer is hard ...

presuming users are logged in and running a program, and that this program is a scripting language then you can execute whoami from the shell and use that value.

If you are using C, then see geteuid() and friends.

Aiden Bell  2009-11-24 15:18:02
My apologies for being not-so-clear. I am using java. In java I can surely fetch the current user and put that value in the column.Actually my intention is not to do this explicitly.I want SQL Server to identify the current user. I could use that value in a trigger that updates the “ModifiedBy” for the updated/inserted rows.But as the things stand, a web application can run on any platform/operating-system and it is that applications duty to provide the current user information to the database.ThanksNayn
Nayn  2009-11-25 06:06:17

related questions

Obscuring network proxy password in plain text files on Linux/UNIX-likes
Why doesn't **find** find anything?
Getting stack traces on Unix systems, automatically
Differences between unix and windows files
How do you do a case insensitive search using a pattern modifier using less ?
Using Visual Studio to develop for C++ for Unix
How do I generate ASCII codes 2 and 3 in a Bash command line?
What's in your .procmailrc
Allow user to set up an SSH tunnel, but nothing else
What is PHP Safe Mode GID?
How to avoid redefining VERSION, PACKAGE, etc.
How can I encode xml files to xfdl (base64-gzip)?
Faster way to find duplicates conditioned by time
Date arithmetic in Unix shell scripts
Using Xming X Window Server over a VPN
Windows Equivalent of 'nice'
How do I configure and communicate with a serial port?
Choosing a static code analysis tool
What should a longtime Windows user know when starting to use Linux?
How do I use (n)curses in Ruby?
Process size on UNIX
Getting root permissions on a file inside of vi?
GTK implementation of MessageBox
Is gettimeofday() guaranteed to be of microsecond resolution?
Fastest way to get value of pi