title: How to find loginname, database username, or roles of sqlserver domain user who doesn't have their own login?
body: <p>I have created a login and database user called "MYDOMAIN\Domain Users". I need to find what roles a logged on domain user has but all the calls to get the current user return the domain username eg. "MYDOMAIN\username" not the database username eg. "MYDOMAIN\Domain Users".</p>
  
  <p>For example, this query returns "MYDOMAIN\username"</p>
  
  <pre><code>select original_login(),suser_name(), suser_sname(), system_user, session_user,  current_user, user_name()
  </code></pre>
  
  <p>And this query returns 0</p>
  
  <pre><code>select USER_ID()
  </code></pre>
  
  <p>I want the username to query database_role_members is there any function that will return it or any other way I can get the current users roles?</p>