Question

Which of the following condition in the where clause will return the login identification name of the user?

(a) UserName = SUSER_NAME()

(b) UserName = SUSER_SNAME()

(c) UserName = CURRENT_USER()

(d) UserName = USER()

I had been asked this question in exam.

The origin of the question is Row Level Security in chapter Security of SQL Server

Answer 1

Right option is (b) UserName = SUSER_SNAME()

To elaborate: USER_NAME or CURRENT_USER Return the database user name.