Different types of Security Functions
Posted on January 17th , 2012 by Admin
|
|
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 |
|
|
