セキュリティ関数 (Transact-SQL)Security Functions (Transact-SQL)

適用対象: ○SQL Server XAzure SQL Database XAzure SQL Data Warehouse XParallel Data WarehouseAPPLIES TO: yesSQL Server noAzure SQL Database noAzure 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)
PERMISSIONS (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)
組み込み関数 (Transact-SQL) Built-in Functions (Transact-SQL)
セキュリティ ステートメントSecurity Statements