SQL Security Functions: Part 4

ISUSER_ID ('login')

SUSER_NAME ([server_user_id])

SQL SUSER_SID Function

This SQL security function returns the security identification number for the specified login name.

Syntax

SUSER_SID(['login'][,param2])

Arguments of the SUSER_SID function

The argument of the function is.

Parameter	Description
login	It is the user's login name; a login is sysname, which is optional and can be a SQL Server login Microsoft Windows user or group.
param2	It specifies whether the login name is validated and param 2 is optional and is of type int.

Example

An example image of the function is.

SQL SUSER_SNAME Function

This SQL security function returns the login name associated with a security identification number; This function can be a default constraint in either ALTER TABLE or CREATE TABLE.

Syntax

SUSER_SNAME ([server_user_id])

Argument of the SUSER_SNAME function

The argument of the function is.

Parameter	Description
server_user_id	It is the login security identification number of the user.

Example

An example image of the function is.

SQL SYSTEM_USER Function

This SQL security function allows a system-supplied value for the current login to be inserted into a table when no default value is specified. You can use the SYSTEM_USER function with DEFAULT constraints in the CREATE and ALTER TABLE statements. You can also use it as any standard function.

Syntax

SYSTEM_USER

Example

An example of the function is.

DECLARE @sys_usr char(30);
SET @sys_usr = SYSTEM_USER;
SELECT 'The current system user is: '+ @sys_usr;

GO

Output