I am having some trouble getting a test to work. I have a package called grantschemaacceess that contains two procs of interest here. One grants access to all objects in a schema to another user and one revokes the same privs. I have setup tests to check the data dictionary if the grants have been granted or revoked. The tests are working fine for the grant but the revoke procedure test is failing. It looks like it is still seeing the grant that occures form the testing of the grant procedure. Doing my own tests I seem to think the program code is working but the test code is not. Can you help me see what is going on here. I will upload the program code and my tests.
PS. Other than this issue I am absolutly loving this tool!
plf_grantschemaaccess.zip (52.1 KB)