After digging and digging and digging, I found that this had to do with my schema ownership in the database.
SubCommander uses the following SQL to get the schema:
"SELECT a.table_name AS Name FROM
user_tables a";
and for views:
"SELECT a.view_name AS Name FROM
user_views a";
Since the schema is owned by a different user and I will not be given that user's account information, I needed to alter the code as follows:
In the OracleProvider class, change the code within the Schema Bits region (it is near 3/4 of the way down the file:
private const string MANY_TO_MANY_LIST = "SELECT b.table_name FROM all_constraints a, all_cons_columns b " +
"WHERE a.table_name = :tableName " +
"AND a.constraint_type = 'R' " +
"AND a.r_constraint_name = b.constraint_name " +
"AND b.table_name like '%' + :mapSuffix";
const string TABLE_COLUMN_SQL = "SELECT user, a.table_name, a.column_name, a.column_id, a.data_default, " +
" a.nullable, a.data_type, a.char_length, a.data_precision, a.data_scale " +
" FROM all_tab_columns a " +
" WHERE a.table_name = :tableName";
const string SP_PARAM_SQL = @"SELECT a.object_name, a.object_type, b.position, b.in_out,
b.argument_name, b.data_type, b.char_length, b.data_precision, b.data_scale
FROM all_objects a, all_arguments b
WHERE a.object_type IN ('PROCEDURE', 'FUNCTION', 'PACKAGE')
AND a.object_id = b.object_id
AND a.object_name = :objectName";
const string SP_SQL = @"SELECT a.object_name, a.object_type, a.created, a.last_ddl_time
` FROM all_objects a
WHERE a.object_type IN ('PROCEDURE', 'FUNCTION', 'PACKAGE') ";
const string TABLE_SQL = "SELECT a.table_name AS Name FROM all_tables a";
const string VIEW_SQL = "SELECT a.view_name AS Name FROM all_views a";
const string INDEX_SQL = "SELECT b.table_name, b.column_name, " +
" DECODE (a.constraint_type, " +
" 'R', 'FOREIGN KEY', " +
" 'P', 'PRIMARY KEY', " +
" 'UNKNOWN' " +
" ) constraint_type " +
" FROM all_constraints a, all_cons_columns b " +
" WHERE a.constraint_name = b.constraint_name " +
" AND a.constraint_type IN ('R', 'P') " +
" AND b.table_name = :tableName ";
const string GET_TABLE_SQL = "SELECT b.table_name " +
" FROM all_constraints a, all_cons_columns b " +
" WHERE a.constraint_name = b.constraint_name " +
" AND a.constraint_type IN ('R', 'P') " +
" AND b.column_name = :columnName " +
" AND a.constraint_type = 'P' ";
const string GET_FOREIGN_KEY_SQL = "SELECT d.table_name " +
" FROM all_cons_columns c, all_cons_columns d, all_constraints e " +
" WHERE d.constraint_name = e.r_constraint_name " +
" AND c.constraint_name = e.constraint_name " +
" AND d.column_name = :columnName " +
" AND e.table_name = :tableName ";
const string GET_PRIMARY_KEY_SQL = "SELECT e.table_name AS TableName, c.column_name AS ColumnName " +
" FROM all_cons_columns c, all_cons_columns d, all_constraints e " +
" WHERE d.constraint_name = e.r_constraint_name " +
" AND c.constraint_name = e.constraint_name " +
" AND d.table_name = :tableName ";
Your database account will need elevated privs. to do this but it will allow your DBA's to help you with that rather than having to know the schema owner.