Administration of Security - Expert Oracle and Java Security - page 360

stmt = (OracleCallableStatement)conn.prepareCall(
"CALL ojsaadm.apver_usr_adm_pkg. p_create_apver_user (?)");
...
// Next, grant or revoke each proxy
if (ojsaadmCheckBox.isSelected()) {
stmt = (OracleCallableStatement)conn.prepareCall(
"CALL sys.usr_role_adm_pkg. p_set_proxy_through (?,?)");
stmt.setString(1, userID);
stmt.setString(2, " OJSAADM ");
...
} else {
stmt = (OracleCallableStatement)conn.prepareCall(
"CALL sys.usr_role_adm_pkg. p_drop_proxy_through (?,?)");
...
}
if (appusrCheckBox.isSelected()) {
stmt = (OracleCallableStatement)conn.prepareCall(
"CALL sys.usr_role_adm_pkg. p_set_proxy_through (?,?)");
stmt.setString(1, userID);
stmt.setString(2, " APPUSR ");
...
} else {
stmt = (OracleCallableStatement)conn.prepareCall(
"CALL sys.usr_role_adm_pkg. p_drop_proxy_through (?,?)");
...
}
if (avadminCheckBox.isSelected()) {
stmt = (OracleCallableStatement)conn.prepareCall(
"CALL sys.usr_role_adm_pkg. p_set_proxy_through (?,?)");
stmt.setString(1, userID);
stmt.setString(2, " AVADMIN ");
...
stmt = (OracleCallableStatement)conn.prepareCall(
"CALL ojsaadm.apver_usr_adm_pkg. p_set_apver_proxy_through (?,?)");
...
stmt = (OracleCallableStatement)conn.prepareCall(
"CALL ojsaadm.apver_usr_adm_pkg. p_grant_apver_appver_conns (?)");
stmt.setString(1, userID);
...
} else {
stmt = (OracleCallableStatement)conn.prepareCall(
"CALL sys.usr_role_adm_pkg. p_drop_proxy_through (?,?)");
...
stmt = (OracleCallableStatement)conn.prepareCall(
"CALL ojsaadm.apver_usr_adm_pkg. p_drop_apver_proxy_through (?,?)");
...
stmt = (OracleCallableStatement)conn.prepareCall(
"CALL ojsaadm.apver_usr_adm_pkg. p_revoke_apver_appver_conns (?)");
...
}
blankAll();