Changed Oracle test-user creation to grant privileges instead of roles

because the roles (specifically RESOURCE) are deprecated.
Also added optional support for creating views in tests.
This line is currently a comment, not seen in the generated documentation. It is in preparation for PR #2899, which will make it true.