System function

Question

Hi, In genral database what is the system function to get the current user's user id? Thanks

Arjun Panwar · Answer

Thanks to all

Chintan Rathod · Answer

Getting Database User Names or User IDs When connected to SQL Server 2000, use: USER_ID to get the database user ID associated with a database user name. USER_ID() to get the database user ID associated with the current connection. USER_NAME to get the database user name associated with a database user ID. Either the SQL-92 CURRENT_USER or SESSION_USER functions to get the database user name associated with the current connection. In Transact-SQL these functions are implemented as synonyms for the USER_NAME() (USER_NAME specified without a database_user_ID parameter). The Transact-SQL function USER is also implemented as a synonym for USER_NAME(). Syntax USER_ID ( [ ' user ' ] ) Arguments ' user ' Is the username to be used. user is nchar . If a char value is specified, it is implicitly converted to nchar . Return Types smallint Remarks When user is omitted, the current user is assumed. Parentheses are required. USER_ID can be used in the select list, in the WHERE clause, and anywhere an expression is allowed. Examples This example returns the identification number for user "Chintan". SELECT USER_ID('Chintan')

Satyapriya Nayak · Answer

Hi Arjun, USER_ID(). other system functions like USER_NAME(), SYSTEM_USER, SESSION_USER, CURRENT_USER, USER, SUSER_SID(), HOST_NAME(). Thanks

System function

Answers (3)