Assert verifies that role exists. Fail when role with a given name could not be found in the database.

Note: Supported in Oracle and SQL Server framework versions.

Arguments

  • v_RoleName – name of the role to be found, 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_ROLE_EXISTS 'read_only_user_role', 'cannot find role';

Oracle 

DBTD_ASSERT_ROLE_EXISTS( 'read_only_user_role', 'cannot find role');

 

See Also