select USER : USER « User Role « SQL Server / T-SQL Tutorial






10> SELECT CURRENT_TIMESTAMP, USER, SYSTEM_USER, CURRENT_USER,
11> SESSION_USER
12> GO



----------------------- -------------------------------------------------------------------------------------------------------------------------------- -----------------------------------------------
--------------------------------------------------------------------------------- ----------------------------------------------------------------------------------------------------------------------
---------- --------------------------------------------------------------------------------------------------------------------------------
2008-08-17 13:20:57.503 dbo                                                                                                                              J\Administrator
                                                                                  dbo
           dbo

(1 rows affected)








28.11.USER
28.11.1.Creating Database Users with schema
28.11.2.select USER
28.11.3.Change the default schema for user Fred
28.11.4.Create a proxy user
28.11.5.Create a user and a table, and make the user own the table
28.11.6.Modifying a Database User for the schema
28.11.7.Modifying a Database User for name
28.11.8.Removing a Database User from the Database