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.