Prasad, looks great! There a few times we expect a sql exception but there is no fail() statement directly below the statement execution to make sure the execution throws a sql exception. Unless there are questions about that, feel free to fix that on commit.
I believe we need a fail() statement below the execute here?
fail() statement missing here and below as well.
ACCESS-108: CREATE TABLE db.table comes through as access for default database
Review Request #2932 - Created April 27, 2013 and updated
- Capture db name for table level DDL operations (the compiler doesn't build write entities for DDLs) - Ensure that all table level DDL are require ALL privilege at DB level - Cleaned test issues with - + removed asserts checks on stmt.execute() which are not required + split the sandbox9 test into two parts and removed the policy file modifications in between test.
The TestCrossDbOps passes with the change