Assert verifies that login does not exists. Fail when login has not 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_NOT_EXISTS 'administrator', 'administrator login should not exist on this server';


See Also