Post reply

system_User

  • May 7, 2007 at 4:40 pm

    #177795

    Hi,

    I am using the system function system_user in some TSQL.  The issue is the result is returning my proper window authentication login.  But the actually login doesn't exist under my security\logins.  This is on my 'local' install of SQL 2005.  I assume I am seen as BUILTIN\ADMINISTRATOR.  We are using this information to see if we need to add users to some of our application tables.  The problem is that the actually Windows Authentication login doesn't exit yet locally.  Is there a way to get around this? 

    What system function would return BUILTIN\ADMINSTRATOR? 

     

    Thanks,

     

    Danile

  • May 7, 2007 at 4:45 pm

    #704794

    Although your are being authenticated through the group BUILTIN\ADMINISTRATORS, system_user still returns who you are.  I do not know of any system functions that will return the group through which you are authenticated.

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply