Funciones de seguridad (Transact-SQL)Security Functions (Transact-SQL)

SE APLICA A: síSQL Server (a partir de 2012) noAzure SQL Database noAzure SQL Data Warehouse noAlmacenamiento de datos paralelos APPLIES TO: yesSQL Server (starting with 2012) noAzure SQL Database noAzure SQL Data Warehouse noParallel Data Warehouse

Las siguientes funciones devuelven información útil para la administración de la seguridad.The following functions return information that is useful in managing security. En Funciones de cifrado (Transact-SQL) se enumeran más funciones.Additional functions are listed under Cryptographic Functions (Transact-SQL).

CERTENCODED (Transact-SQL)CERTENCODED (Transact-SQL) PWDCOMPARE (Transact-SQL)PWDCOMPARE (Transact-SQL)
CERTPRIVATEKEY (Transact-SQL)CERTPRIVATEKEY (Transact-SQL) PWDENCRYPT (Transact-SQL)PWDENCRYPT (Transact-SQL)
CURRENT_USER (Transact-SQL)CURRENT_USER (Transact-SQL) SCHEMA_ID (Transact-SQL)SCHEMA_ID (Transact-SQL)
DATABASE_PRINCIPAL_ID (Transact-SQL)DATABASE_PRINCIPAL_ID (Transact-SQL) SCHEMA_NAME (Transact-SQL)SCHEMA_NAME (Transact-SQL)
sys.fn_builtin_permissions (Transact-SQL)sys.fn_builtin_permissions (Transact-SQL) SESSION_USER (Transact-SQL)SESSION_USER (Transact-SQL)
sys.fn_get_audit_file (Transact-SQL)sys.fn_get_audit_file (Transact-SQL) SUSER_ID (Transact-SQL)SUSER_ID (Transact-SQL)
sys.fn_my_permissions (Transact-SQL)sys.fn_my_permissions (Transact-SQL) SUSER_SID (Transact-SQL)SUSER_SID (Transact-SQL)
HAS_PERMS_BY_NAME (Transact-SQL)HAS_PERMS_BY_NAME (Transact-SQL) SUSER_SNAME (Transact-SQL)SUSER_SNAME (Transact-SQL)
IS_MEMBER (Transact-SQL)IS_MEMBER (Transact-SQL) SYSTEM_USER (Transact-SQL)SYSTEM_USER (Transact-SQL)
IS_ROLEMEMBER (Transact-SQL)IS_ROLEMEMBER (Transact-SQL) SUSER_NAME (Transact-SQL)SUSER_NAME (Transact-SQL)
IS_SRVROLEMEMBER (Transact-SQL)IS_SRVROLEMEMBER (Transact-SQL) USER_ID (Transact-SQL)USER_ID (Transact-SQL)
ORIGINAL_LOGIN (Transact-SQL)ORIGINAL_LOGIN (Transact-SQL) USER_NAME (Transact-SQL)USER_NAME (Transact-SQL)
PERMISSIONS (Transact-SQL)PERMISSIONS (Transact-SQL)

Para más información sobre la pertenencia a grupos de Windows, vea xp_logininfo (Transact-SQL) y xp_enumgroups (Transact-SQL).For information about membership in Windows groups, see xp_logininfo (Transact-SQL) and xp_enumgroups (Transact-SQL).

Consulte tambiénSee Also

Procedimientos almacenados de seguridad (Transact-SQL) Security Stored Procedures (Transact-SQL)
Funciones de cifrado (Transact-SQL) Cryptographic Functions (Transact-SQL)
Funciones integradas (Transact-SQL) Built-in Functions (Transact-SQL)
Instrucciones de seguridadSecurity Statements