Different types of Security Functions
Security functions are basically used to get information about users and there roles. All the security functions are nondeterministic means they return different value every time they are called with a specific set of values or parameters. Below are the list of some security functions available in sql server. (1)fn_trace_geteventinfo (2)fn_trace_getfilterinfo (3)fn_trace_getinfo (4)fn_trace_gettable (5)HAS_DBACCESS (6)IS_MEMBER (7)IS_SRVROLEMEMBER (8)SUSER_SID (9)SUSER_SNAME (10)USER_ID (11)USER