Assert verifies that login exists. Fail when login with a given name has not been found on the server.
Note: Supported in SQL Server framework version.
Arguments
-
v_LoginName – login name, Variable Character(255) in Oracle and Netezza, SYSNAME in SQL Server
-
v_UserMessage – message to report when assertion fails, Variable Character(255) in Oracle and Netezza, NVARCHAR(MAX) in SQL Server
Examples
SQL Server
EXEC DBTD_ASSERT_LOGIN_EXISTS 'administrator', 'cannot find login';
See Also