sql server (microsoft): Hi:

Is there some way of accessing the username (SQL Account) that is
running a stored procedure? Basically, in the absence of good row level
security options in this verison of SQL, I want to create a proc like
this:
----------
DECLARE @username

SELECT @username = userfield FROM
PossibleSystemTableWhereCurrentSQLUsernameStored

If @username = 'usera'
BEGIN
SELECT * FROM table1 WHERE conditionfield = 'useravalue'
END

IF @username = 'userb'
BEGIN
SELECT * FROM table1 WHERE conditionfield = 'userbvalue'
END
----------

Is this possible?

Thanks,
Kayda

select SUSER_SNAME() should give you the current login.

These articles may be of some help:

By SQL Server MVP Narayana Vyas
http://vyaskn.tripod.com/row_level_security_in_sql_server_databases.htm

SQL Mag (Subscriber only, but you can still download the code)
http://www.windowsitpro.com/SQLServer/Article/ArticleID/42615/42615.html

HTH,

BZ