보안 함수(Transact-SQL)Security Functions (Transact-SQL)

이 항목은 다음에 적용됩니다.예SQL Server(2012부터)아니요Azure SQL Database아니요Azure SQL Data Warehouse 아니요병렬 데이터 웨어하우스 THIS TOPIC APPLIES TO: yesSQL Server (starting with 2012)noAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

다음 보안 함수는 보안 관리에 유용한 정보를 반환합니다.The following functions return information that is useful in managing security. 추가 기능 아래에 나열 됩니다 암호화 함수 ( Transact SQL ) .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)
사용 권한 ( Transact SQL )PERMISSIONS (Transact-SQL)

Windows 그룹의 구성원 자격에 대 한 정보를 참조 하십시오. xp_logininfo ( Transact SQL ) xp_enumgroups ( Transact SQL ) .For information about membership in Windows groups, see xp_logininfo (Transact-SQL) and xp_enumgroups (Transact-SQL).

관련 항목:See Also

보안 저장 프로시저 ( Transact SQL ) Security Stored Procedures (Transact-SQL)
암호화 함수 ( Transact SQL ) Cryptographic Functions (Transact-SQL)
기본 제공 함수s(Transact-SQL) Built-in Functions (Transact-SQL)
보안 문Security Statements