Assert verifies that user  does not exists. Fail when user with a given name is found.

Arguments

  • v_UserName – name of the user, 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_USER_NOT_EXISTS 'superuser', 'found user';

Oracle

DBTD_ASSERT_USER_NOT_EXISTS('superuser', 'found user');

Netezza

CALL DBTD_ASSERT_USER_NOT_EXISTS('superuser', 'found user');

 

See Also