public class DBOAccessTest extends GeneratedColumnsHelper
Modifier and Type | Class and Description |
---|---|
static class |
DBOAccessTest.NoAuthorization |
Modifier and Type | Field and Description |
---|---|
private static java.lang.String |
HIDDEN_COLUMN |
private static java.lang.String |
JANET |
private static java.lang.String[] |
LEGAL_USERS |
private static java.lang.String |
ONLY_DBO |
private static java.lang.String |
TEST_DBO |
private static java.lang.String |
TEST_LOG_FILE |
BAD_BEFORE_TRIGGER, BAD_CAST, BAD_FOREIGN_KEY_ACTION, CANT_ADD_IDENTITY, CANT_CONTAIN_NULLS, CANT_MODIFY_IDENTITY, CANT_OVERRIDE_GENERATION_CLAUSE, CANT_REFERENCE_GENERATED_COLUMN, CASCADED_COLUMN_DROP_WARNING, COLUMN_OUT_OF_SCOPE, CONSTRAINT_DROPPED_WARNING, CONSTRAINT_VIOLATION, DUPLICATE_CLAUSE, FORBIDDEN_DROP_TRIGGER, FORBIDDEN_ORDERING_OPERATION, FOREIGN_KEY_VIOLATION, GRANT_REVOKE_NOT_ALLOWED, ILLEGAL_ADD_DEFAULT, ILLEGAL_AGG, ILLEGAL_AGGREGATE, ILLEGAL_COMPARISON, ILLEGAL_DUPLICATE, ILLEGAL_RENAME, ILLEGAL_STORAGE, ILLEGAL_UDT_CLASS, JAVA_EXCEPTION, LACK_COLUMN_PRIV, LACK_EXECUTE_PRIV, LACK_TABLE_PRIV, LACK_USAGE_PRIV, LANG_INVALID_USE_OF_DEFAULT, LOCK_TIMEOUT, MISSING_OBJECT, NEED_EXPLICIT_DATATYPE, NON_EMPTY_SCHEMA, NONEXISTENT_OBJECT, NOT_NULL_NEEDS_DATATYPE, NOT_NULL_VIOLATION, OBJECT_DOES_NOT_EXIST, OPERATION_FORBIDDEN, REDUNDANT_CLAUSE, ROUTINE_CANT_ISSUE_SQL, ROUTINE_DEPENDS_ON_TYPE, STRING_TRUNCATION, SYNTAX_ERROR, TABLE_DEPENDS_ON_TYPE, TOO_MUCH_CONTENTION, TRIGGER_DROPPED_WARNING, UNSTABLE_RESULTS, VIEW_DEPENDENCY
DEFAULT_DB_DIR, DERBY_LOG, ERRORSTACKTRACEFILE
Constructor and Description |
---|
DBOAccessTest(java.lang.String name)
Create a new instance.
|
Modifier and Type | Method and Description |
---|---|
boolean |
authorizationIsOn() |
private void |
minion_5395(java.sql.Connection conn,
boolean shouldSucceed) |
static junit.framework.Test |
suite()
Construct top level suite in this JUnit test
|
void |
test_5395()
Tests that only the DBO can run diagnostic VTIs which return sensitive information.
|
void |
testSYSUSERS()
Tests that only the DBO can select from SYSUSERS and no-one can SELECT
SYSUSERS.PASSWORD.
|
private void |
vet_5395(java.sql.Connection conn,
boolean shouldSucceed,
java.lang.String query) |
private void |
vetDBO_OKProbes(java.sql.Connection conn,
boolean shouldSucceed) |
private void |
vetUnauthorizedProbes(java.sql.Connection conn,
boolean shouldSucceed,
java.lang.String expectedSQLState) |
private void |
vetUserProbes(java.sql.Connection conn,
boolean shouldSucceed,
java.lang.String query,
java.lang.String expectedSQLState) |
assertColumnTypes, assertDeterministic, assertResults, assertResults, chattyPrepare, chattyPrepareCall, executeQuery, expectCompilationError, expectCompilationError, expectExecutionError, expectExecutionWarning, expectExecutionWarnings, expectInsertRowError, expectUpdateRowError, fill, goodStatement, verifyRestrictedDrop, verifyRevokePrivilege
assertCallError, assertCheckTable, assertCompileError, assertEquals, assertEquals, assertEquals, assertEquivalentDataType, assertErrorCode, assertGetIntError, assertNextError, assertPreparedStatementError, assertSQLExceptionEquals, assertSQLState, assertSQLState, assertStatementError, assertStatementError, assertStatementError, assertStatementError, assertStatementErrorUnordered, assertTableRowCount, assertUpdateCount, assertUpdateCount, assertWarning, checkAllConsistency, checkEstimatedRowCount, closeStatement, commit, createStatement, createStatement, createStatement, dropTable, dropTable, dropView, dropView, emptyStatementCache, getClientTransactionID, getConnection, getDatabaseProperty, getLastSQLException, initializeConnection, openConnection, openDefaultConnection, openDefaultConnection, openDefaultConnection, openUserConnection, prepareCall, prepareCall, prepareCall, prepareStatement, prepareStatement, prepareStatement, prepareStatement, prepareStatement, prepareStatement, rollback, runBare, runBareOverridable, runScript, runScript, runSQLCommands, setAutoCommit, tearDown, usingDB2Client, usingDerbyNetClient, usingEmbedded
alarm, assertDirectoryDeleted, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertExecJavaCmdAsExpected, assertLaunchedJUnitTestMethod, assertLaunchedJUnitTestMethod, assertSecurityManager, assertThrowableEquals, currentDirectory, execJavaCmd, execJavaCmd, fail, getClassVersionMajor, getEmmaJar, getFailureFolder, getFilesWith, getJavaExecutableName, getSystemProperty, getTestConfiguration, getTestResource, hasInterruptibleIO, isCVM, isIBMJVM, isJ9Platform, isJava5, isJava7, isJava8, isPhoneME, isPlatform, isSunJVM, isWindowsPlatform, openTestResource, println, printStackTrace, readProcessOutput, removeDirectory, removeDirectory, removeFiles, removeSystemProperty, runsWithEmma, runsWithJaCoCo, setSystemProperty, sleep, sleepAtLeastOneTick, traceit
assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertFalse, assertFalse, assertNotNull, assertNotNull, assertNotSame, assertNotSame, assertNull, assertNull, assertSame, assertSame, assertTrue, assertTrue, countTestCases, createResult, fail, fail, failNotEquals, failNotSame, failSame, format, getName, run, run, runTest, setName, setUp, toString
private static final java.lang.String TEST_DBO
private static final java.lang.String JANET
private static final java.lang.String[] LEGAL_USERS
private static final java.lang.String TEST_LOG_FILE
private static final java.lang.String ONLY_DBO
private static final java.lang.String HIDDEN_COLUMN
public boolean authorizationIsOn()
public static junit.framework.Test suite()
public void test_5395() throws java.lang.Exception
Tests that only the DBO can run diagnostic VTIs which return sensitive information. See DERBY-5395.
java.lang.Exception
private void minion_5395(java.sql.Connection conn, boolean shouldSucceed) throws java.lang.Exception
java.lang.Exception
private void vet_5395(java.sql.Connection conn, boolean shouldSucceed, java.lang.String query) throws java.lang.Exception
java.lang.Exception
public void testSYSUSERS() throws java.lang.Exception
Tests that only the DBO can select from SYSUSERS and no-one can SELECT SYSUSERS.PASSWORD.
java.lang.Exception
private void vetDBO_OKProbes(java.sql.Connection conn, boolean shouldSucceed) throws java.lang.Exception
java.lang.Exception
private void vetUnauthorizedProbes(java.sql.Connection conn, boolean shouldSucceed, java.lang.String expectedSQLState) throws java.lang.Exception
java.lang.Exception
private void vetUserProbes(java.sql.Connection conn, boolean shouldSucceed, java.lang.String query, java.lang.String expectedSQLState) throws java.lang.Exception
java.lang.Exception
Apache Derby V10.10 Internals - Copyright © 2004,2014 The Apache Software Foundation. All Rights Reserved.