This class of asserts will verify different permissions and security expectations

N - Netezza
O - Oracle
S - SQL Server

Assert Procedure N O S Description
Permissions and Security Assertions 
DBTD_ASSERT_USER_EXISTS + + + Assert verifies that user exists. Fail when user with a given name could not be found.
DBTD_ASSERT_USER_NOT_EXISTS + + + Assert verifies that user  does not exists. Fail when user with a given name is found.
DBTD_ASSERT_ROLE_EXISTS   + + Assert verifies that role exists. Fail when role with a given name could not be found in the database.
DBTD_ASSERT_ROLE_NOT_EXISTS   + + Assert verifies that role does not exists. Fail when role with a given name found in the database.
DBTD_ASSERT_LOGIN_EXISTS     + Assert verifies that login exists. Fail when login with a given name has not been found on the server.
DBTD_ASSERT_LOGIN_NOT_EXISTS     + Assert verifies that login does not exists. Fail when login has not found on the server.
Assert Procedure N O S Description

N - Netezza
O - Oracle
S - SQL Server

 

Assert procedures should not be altered.