Rem drv: <migrate type="data_upgrade" version="10.2.0.4"/>
Rem
Rem $Header: credentials_data_upgrade.sql 24-may-2007.02:39:20 kmanicka Exp $
Rem
Rem credentials_data_upgrade.sql
Rem
Rem Copyright (c) 2006, 2007, Oracle. All rights reserved.  
Rem
Rem    NAME
Rem      credentials_data_upgrade.sql - <one-line expansion of the name>
Rem
Rem    DESCRIPTION
Rem      <short description of component this file declares/defines>
Rem
Rem    NOTES
Rem      <other useful comments, qualifications, etc.>
Rem
Rem    MODIFIED   (MM/DD/YY)
Rem    kmanicka    05/24/07 - Changing Rep Hearde
Rem    dgiaimo     04/30/07 - Changing 10.2.4.0 to 10.2.0.4
Rem    nqureshi    09/08/06 - 
Rem    kmanicka    07/03/06 - Created
Rem

-- create sudo pdp type
BEGIN
DECLARE
l_pdp_columns MGMT_PDP_COLUMN_META_ARRAY := MGMT_PDP_COLUMN_META_ARRAY();
l_pdp_settings MGMT_PDP_SETTING_META_ARRAY := MGMT_PDP_SETTING_META_ARRAY();
l_pdp_params MGMT_PDP_PARAM_META_ARRAY := MGMT_PDP_PARAM_META_ARRAY();
l_pdp MGMT_PDP_META;
BEGIN
    l_pdp_columns.extend(1);
    l_pdp_columns(1) := MGMT_PDP_COLUMN_META.NEW(MGMT_CREDENTIAL.PDP_COLUMN_RUNAS,1);

    l_pdp_settings.extend(1);
    l_pdp_settings(1) := MGMT_PDP_SETTING_META.NEW(MGMT_CREDENTIAL.PDP_SUDO_SETTING,
                                                   MGMT_CREDENTIAL.PDP_SETTING_REQUIRED,
                                                   MGMT_CREDENTIAL.PDP_SUDO_SETTING || '_display_name_nlsid',
                                                   MGMT_CREDENTIAL.PDP_SUDO_SETTING || '_display_name',
                                                   MGMT_CREDENTIAL.PDP_SUDO_SETTING || '_hint_nlsid',
                                                   MGMT_CREDENTIAL.PDP_SUDO_SETTING || '_hint');

    l_pdp_params.extend(4);
    l_pdp_params(1) := MGMT_PDP_PARAM_META.NEW(MGMT_CREDENTIAL.PDP_PARAM_COMMAND,
                                               MGMT_CREDENTIAL.PDP_PARAM_COMMAND || '_description_nlsid',
                                               MGMT_CREDENTIAL.PDP_PARAM_COMMAND || '_description');

    l_pdp_params(2) := MGMT_PDP_PARAM_META.NEW(MGMT_CREDENTIAL.PDP_PARAM_USERNAME,
                                               MGMT_CREDENTIAL.PDP_PARAM_USERNAME || '_description_nlsid',
                                               MGMT_CREDENTIAL.PDP_PARAM_USERNAME || '_description');

    l_pdp_params(3) := MGMT_PDP_PARAM_META.NEW(MGMT_CREDENTIAL.PDP_PARAM_PASSWORD,
                                               MGMT_CREDENTIAL.PDP_PARAM_PASSWORD || '_description_nlsid',
                                               MGMT_CREDENTIAL.PDP_PARAM_PASSWORD || '_description');

    l_pdp_params(4) := MGMT_PDP_PARAM_META.NEW(MGMT_CREDENTIAL.PDP_PARAM_RUNAS,
                                               MGMT_CREDENTIAL.PDP_PARAM_RUNAS || '_description_nlsid',
                                               MGMT_CREDENTIAL.PDP_PARAM_RUNAS || '_description');


    l_pdp := MGMT_PDP_META.NEW(MGMT_CREDENTIAL.PDP_SUDO,
                               'HostCreds',
                               l_pdp_columns,
                               l_pdp_settings,
                               l_pdp_params);

    MGMT_CREDENTIAL.create_pdp_type(l_pdp);

END;
END;
/

-- create powerbroker pdp type
BEGIN
DECLARE
l_pdp_columns MGMT_PDP_COLUMN_META_ARRAY := MGMT_PDP_COLUMN_META_ARRAY();
l_pdp_settings MGMT_PDP_SETTING_META_ARRAY := MGMT_PDP_SETTING_META_ARRAY();
l_pdp_params MGMT_PDP_PARAM_META_ARRAY := MGMT_PDP_PARAM_META_ARRAY();
l_pdp MGMT_PDP_META;
BEGIN
    l_pdp_columns.extend(2);
    l_pdp_columns(1) := MGMT_PDP_COLUMN_META.NEW(MGMT_CREDENTIAL.PDP_COLUMN_RUNAS,1);
    l_pdp_columns(2) := MGMT_PDP_COLUMN_META.NEW(MGMT_CREDENTIAL.PDP_COLUMN_PROFILE,0);

    l_pdp_settings.extend(1);
    l_pdp_settings(1) := MGMT_PDP_SETTING_META.NEW(MGMT_CREDENTIAL.PDP_POWERBROKER_SETTING,
                                                   MGMT_CREDENTIAL.PDP_SETTING_REQUIRED,
                                                   MGMT_CREDENTIAL.PDP_POWERBROKER_SETTING || '_display_name_nlsid',
                                                   MGMT_CREDENTIAL.PDP_POWERBROKER_SETTING || '_display_name',
                                                   MGMT_CREDENTIAL.PDP_POWERBROKER_SETTING || '_hint_nlsid',
                                                   MGMT_CREDENTIAL.PDP_POWERBROKER_SETTING || '_hint');

    l_pdp_params.extend(5);
    l_pdp_params(1) := MGMT_PDP_PARAM_META.NEW(MGMT_CREDENTIAL.PDP_PARAM_COMMAND,
                                               MGMT_CREDENTIAL.PDP_PARAM_COMMAND || '_description_nlsid',
                                               MGMT_CREDENTIAL.PDP_PARAM_COMMAND || '_description');

    l_pdp_params(2) := MGMT_PDP_PARAM_META.NEW(MGMT_CREDENTIAL.PDP_PARAM_USERNAME,
                                               MGMT_CREDENTIAL.PDP_PARAM_USERNAME || '_description_nlsid',
                                               MGMT_CREDENTIAL.PDP_PARAM_USERNAME || '_description');

    l_pdp_params(3) := MGMT_PDP_PARAM_META.NEW(MGMT_CREDENTIAL.PDP_PARAM_PASSWORD,
                                               MGMT_CREDENTIAL.PDP_PARAM_PASSWORD || '_description_nlsid',
                                               MGMT_CREDENTIAL.PDP_PARAM_PASSWORD || '_description');

    l_pdp_params(4) := MGMT_PDP_PARAM_META.NEW(MGMT_CREDENTIAL.PDP_PARAM_RUNAS,
                                               MGMT_CREDENTIAL.PDP_PARAM_RUNAS || '_description_nlsid',
                                               MGMT_CREDENTIAL.PDP_PARAM_RUNAS || '_description');

    l_pdp_params(5) := MGMT_PDP_PARAM_META.NEW(MGMT_CREDENTIAL.PDP_PARAM_PROFILE,
                                               MGMT_CREDENTIAL.PDP_PARAM_PROFILE || '_description_nlsid',
                                               MGMT_CREDENTIAL.PDP_PARAM_PROFILE || '_description');

    l_pdp := MGMT_PDP_META.NEW(MGMT_CREDENTIAL.PDP_POWERBROKER,
                               'HostCreds',
                               l_pdp_columns,
                               l_pdp_settings,
                               l_pdp_params);

    MGMT_CREDENTIAL.create_pdp_type(l_pdp);


END;
END;
/