org.apache.derbyTesting.functionTests.tests.lang

Class GrantRevokeDDLTest

java.lang.Object

junit.framework.Assert

junit.framework.TestCase

org.apache.derbyTesting.junit.BaseTestCase

org.apache.derbyTesting.junit.BaseJDBCTestCase

org.apache.derbyTesting.functionTests.tests.lang.GrantRevokeDDLTest

All Implemented Interfaces:

junit.framework.Test

public final class GrantRevokeDDLTest
extends BaseJDBCTestCase

Field Summary

Fields

Modifier and Type	Field and Description
private static java.lang.String[]	users

Fields inherited from class org.apache.derbyTesting.junit.BaseTestCase

DEFAULT_DB_DIR, DERBY_LOG, ERRORSTACKTRACEFILE

Constructor Summary

Constructors

Constructor and Description
GrantRevokeDDLTest(java.lang.String name) Public constructor required for running test as standalone JUnit.

Method Summary

Modifier and Type	Method and Description
static junit.framework.Test	suite()
void	test_derby_4502() DERBY-4502 Allow creation of views against system tables when authorization is enabled.
void	testAlterTablePrivilegesIntace()
void	testAlterTableWithPrivileges()
void	testGlobalTempTables() DERBY-3266
void	testGrantRevokeDDL()
void	testGrantRevokeDDL2()
void	testMinimumSelectPrivilegeRequirement() DERBY-4191 Make sure that we check for atleast table level select privilege or any column level select privilege for following kind of queries select count(*) from t1 select count(1) from t1 select 1 from t1 select t1.c1 from t1, t2
void	testRevokeDropsFKWithSharedConglom() Test the situation where a REVOKE leads to the dropping of a foreign key's backing conglomerate when that conglomerate is shared by other indexes/constraints.

Methods inherited from class org.apache.derbyTesting.junit.BaseJDBCTestCase

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

Methods inherited from class org.apache.derbyTesting.junit.BaseTestCase

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

Methods inherited from class junit.framework.TestCase

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

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, wait, wait, wait

Field Detail

users

private static java.lang.String[] users

Constructor Detail

GrantRevokeDDLTest

public GrantRevokeDDLTest(java.lang.String name)

Public constructor required for running test as standalone JUnit.

Method Detail

suite

public static junit.framework.Test suite()

testGrantRevokeDDL

public void testGrantRevokeDDL()
                        throws java.lang.Exception

Throws:

java.lang.Exception

testGrantRevokeDDL2

public void testGrantRevokeDDL2()
                         throws java.sql.SQLException

Throws:

java.sql.SQLException

testRevokeDropsFKWithSharedConglom

public void testRevokeDropsFKWithSharedConglom()
                                        throws java.sql.SQLException

Test the situation where a REVOKE leads to the dropping of a foreign key's backing conglomerate when that conglomerate is shared by other indexes/constraints. If that happens then a new backing conglomerate must be created (or at least, the old one should be updated accordingly). Note: Such dropping of a foreign key's shared conglomerate is not actually possible at the moment, but this test exercises the logic that checks for such a situation and ensures that it works correctly (i.e. that it does not attempt to create a a new/updated conglomerate). If DERBY-2204 and/or DERBY-3300 is implemented, then this fixture can be modified to actually test the drop and re- create of a new backing conglomerate as the result of a REVOKE--but for now that's not (shoudn't be) possible.

Throws:

java.sql.SQLException

testMinimumSelectPrivilegeRequirement

public void testMinimumSelectPrivilegeRequirement()
                                           throws java.sql.SQLException

DERBY-4191 Make sure that we check for atleast table level select privilege or any column level select privilege for following kind of queries select count(*) from t1 select count(1) from t1 select 1 from t1 select t1.c1 from t1, t2

Throws:

java.sql.SQLException

testGlobalTempTables

public void testGlobalTempTables()
                          throws java.sql.SQLException

DERBY-3266

Throws:

java.sql.SQLException

test_derby_4502

public void test_derby_4502()
                     throws java.lang.Exception

DERBY-4502 Allow creation of views against system tables when authorization is enabled.

Throws:

java.lang.Exception

testAlterTablePrivilegesIntace

public void testAlterTablePrivilegesIntace()
                                    throws java.lang.Exception

Throws:

java.lang.Exception

testAlterTableWithPrivileges

public void testAlterTableWithPrivileges()
                                  throws java.lang.Exception

Throws:

java.lang.Exception