GrantRevokeDDLTest (Apache Derby V10.14 Test Javadoc)

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
`static java.lang.String`	`NO_GENERIC_PERMISSION`
`static java.lang.String`	`NO_SELECT_OR_UPDATE_PERMISSION`
`static java.lang.String`	`NO_TABLE_PERMISSION`
`private static java.lang.String`	`RUTH`
`private static java.lang.String`	`TEST_DBO`
`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.

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

Method Summary

All Methods Static Methods Instance Methods Concrete Methods
Modifier and Type	Method and Description
`private void`	`grant_6429(java.sql.Connection conn, java.lang.String permission)`
`private void`	`revoke_6429(java.sql.Connection conn, java.lang.String permission)`
`static junit.framework.Test`	`suite()`
`void`	`test_6429_tableFunctions()` Test that UPDATE statements require the correct privileges as described on DERBY-6429.
`void`	`test_6429_tables()` Test that UPDATE statements require the correct privileges as described on DERBY-6429.
`void`	`test_6429_views()` Test that UPDATE statements require the correct privileges as described on DERBY-6429.
`void`	`test_6432()` Test that INSERT and UPDATEs run CHECK constraints with definer's rights.
`void`	`test_6433()` Test that INSERT and UPDATEs run generation expressions with definer's rights.
`void`	`test_6434_delete()` Test that DELETE statements require the correct privileges as described on DERBY-6434.
`void`	`test_6434_insert()` Test that INSERT statements require the correct privileges as described on DERBY-6434.
`void`	`test_6434_select()` Test that INSERT statements driven by SELECTs require the correct privileges as described on DERBY-6434.
`void`	`test_6491()` Test that SELECT does not require USAGE privilege on the user-defined types of the table columns.
`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.
`private void`	`vetPermission_6429(Permission permission, java.sql.Connection dboConnection, java.sql.Connection ruthConnection, java.lang.String update)` Verify that the update fails with the correct error after you revoke a permission and that the update succeeds after you add the permission back.

Methods inherited from class org.apache.derbyTesting.junit.BaseJDBCTestCase
assertCallError, assertCheckTable, assertCommitError, assertCompileError, assertEquals, assertEquals, assertEquals, assertEquivalentDataType, assertErrorCode, assertGetIntError, assertNextError, assertPreparedStatementError, assertResults, assertResults, assertSQLExceptionEquals, assertSQLState, assertSQLState, assertStatementError, assertStatementError, assertStatementError, assertStatementError, assertStatementErrorUnordered, assertTableRowCount, assertUpdateCount, assertUpdateCount, assertWarning, chattyPrepare, chattyPrepareCall, checkAllConsistency, checkEstimatedRowCount, closeStatement, commit, createStatement, createStatement, createStatement, dropTable, dropTable, dropView, dropView, dumpRs, dumpRs, emptyStatementCache, executeQuery, expectCompilationError, expectCompilationError, expectExecutionError, getClientTransactionID, getConnection, getDatabaseProperty, getLastSQLException, goodStatement, goodUpdate, 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, assertEquals, assertExecJavaCmdAsExpected, assertLaunchedJUnitTestMethod, assertLaunchedJUnitTestMethod, assertSameNullness, assertSecurityManager, assertThrowableEquals, currentDirectory, execJavaCmd, execJavaCmd, execJavaCmd, fail, getClassVersionMajor, getEmmaJar, getFailureFolder, getFilesWith, getJavaExecutableName, getSystemProperty, getTestConfiguration, getTestResource, hasInterruptibleIO, isCVM, isIBMJVM, isJ9Platform, isJava5, isJava7, isJava8, isPhoneME, isPlatform, isSunJVM, isWindowsPlatform, newAssertionFailedError, openTestResource, println, printStackTrace, readProcessOutput, removeDirectory, removeDirectory, removeFiles, removeSystemProperty, runsWithEmma, runsWithJaCoCo, setSystemErr, setSystemOut, setSystemProperty, sleep, sleepAtLeastOneTick, traceit, vmAtLeast

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
  - TEST_DBO
```
private static final java.lang.String TEST_DBO
```
    See Also:
    
    Constant Field Values
  - RUTH
```
private static final java.lang.String RUTH
```
    See Also:
    
    Constant Field Values
  - users
```
private static java.lang.String[] users
```
  - NO_GENERIC_PERMISSION
```
public static final java.lang.String NO_GENERIC_PERMISSION
```
    See Also:
    
    Constant Field Values
  - NO_SELECT_OR_UPDATE_PERMISSION
```
public static final java.lang.String NO_SELECT_OR_UPDATE_PERMISSION
```
    See Also:
    
    Constant Field Values
  - NO_TABLE_PERMISSION
```
public static final java.lang.String NO_TABLE_PERMISSION
```
    See Also:
    
    Constant Field Values
- 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
  - test_6429_tables
```
public void test_6429_tables()
                      throws java.lang.Exception
```
    Test that UPDATE statements require the correct privileges as described on DERBY-6429. Tables are referenced in SET and WHERE clauses.
    
    Throws:
    
    java.lang.Exception
  - vetPermission_6429
```
private void vetPermission_6429(Permission permission,
                                java.sql.Connection dboConnection,
                                java.sql.Connection ruthConnection,
                                java.lang.String update)
                         throws java.lang.Exception
```
    Verify that the update fails with the correct error after you revoke a permission and that the update succeeds after you add the permission back.
    
    Throws:
    
    java.lang.Exception
  - grant_6429
```
private void grant_6429(java.sql.Connection conn,
                        java.lang.String permission)
                 throws java.lang.Exception
```
    Throws:
    
    java.lang.Exception
  - revoke_6429
```
private void revoke_6429(java.sql.Connection conn,
                         java.lang.String permission)
                  throws java.lang.Exception
```
    Throws:
    
    java.lang.Exception
  - test_6429_views
```
public void test_6429_views()
                     throws java.lang.Exception
```
    Test that UPDATE statements require the correct privileges as described on DERBY-6429. Views are referenced in SET and WHERE clauses.
    
    Throws:
    
    java.lang.Exception
  - test_6429_tableFunctions
```
public void test_6429_tableFunctions()
                              throws java.lang.Exception
```
    Test that UPDATE statements require the correct privileges as described on DERBY-6429. Table functions are referenced in SET and WHERE clauses.
    
    Throws:
    
    java.lang.Exception
  - test_6434_insert
```
public void test_6434_insert()
                      throws java.lang.Exception
```
    Test that INSERT statements require the correct privileges as described on DERBY-6434.
    
    Throws:
    
    java.lang.Exception
  - test_6434_delete
```
public void test_6434_delete()
                      throws java.lang.Exception
```
    Test that DELETE statements require the correct privileges as described on DERBY-6434.
    
    Throws:
    
    java.lang.Exception
  - test_6434_select
```
public void test_6434_select()
                      throws java.lang.Exception
```
    Test that INSERT statements driven by SELECTs require the correct privileges as described on DERBY-6434.
    
    Throws:
    
    java.lang.Exception
  - test_6432
```
public void test_6432()
               throws java.lang.Exception
```
    Test that INSERT and UPDATEs run CHECK constraints with definer's rights.
    
    Throws:
    
    java.lang.Exception
  - test_6433
```
public void test_6433()
               throws java.lang.Exception
```
    Test that INSERT and UPDATEs run generation expressions with definer's rights.
    
    Throws:
    
    java.lang.Exception
  - test_6491
```
public void test_6491()
               throws java.lang.Exception
```
    Test that SELECT does not require USAGE privilege on the user-defined types of the table columns.
    
    Throws:
    
    java.lang.Exception

Class GrantRevokeDDLTest

Field Summary

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

Constructor Summary

Method Summary

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

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

Methods inherited from class junit.framework.TestCase

Methods inherited from class java.lang.Object

Field Detail

TEST_DBO

RUTH

users

NO_GENERIC_PERMISSION

NO_SELECT_OR_UPDATE_PERMISSION

NO_TABLE_PERMISSION

Constructor Detail

GrantRevokeDDLTest

Method Detail

suite

testGrantRevokeDDL

testGrantRevokeDDL2

testRevokeDropsFKWithSharedConglom

testMinimumSelectPrivilegeRequirement

testGlobalTempTables

test_derby_4502

testAlterTablePrivilegesIntace

testAlterTableWithPrivileges

test_6429_tables

vetPermission_6429

grant_6429

revoke_6429

test_6429_views

test_6429_tableFunctions

test_6434_insert

test_6434_delete

test_6434_select

test_6432

test_6433

test_6491