These scalar functions return information about users and roles.
| fn_trace_geteventinfo | IS_SRVROLEMEMBER |
| fn_trace_getfilterinfo | SUSER_SID |
| fn_trace_getinfo | SUSER_SNAME |
| fn_trace_gettable | USER_ID |
| HAS_DBACCESS | USER |
| IS_MEMBER |
All security functions are nondeterministic. They do not always return the same results every time they are called with a specific set of input values. For more information about function determinism, see Deterministic and Nondeterministic Functions.