Allow new PPM installation to use an existing DB User (9.62+)

Idea ID 2841296

Allow new PPM installation to use an existing DB User (9.62+)

Team, 

Enable GUI based Installation for PPM 9.62, this helps in controlling what permissions are being granted to ppm schema by system user, otherwise DBA has no control on privileges granted to the ppm user. Hope to see the feature soon !!

5 Comments
Micro Focus Expert
Micro Focus Expert
Status changed to: New Idea

Hi,

I don't quite understand what you're asking. How is a GUI related to the control of the privileges granted to PPM DB user?

All the grants required during installation & upgrade are document in PPM Upgrade & Installation guide:

https://admhelp.microfocus.com/ppm/en/latest/Help/Content/SA/InstallAdmin/102100_InstallAdmin_Install.htm

https://admhelp.microfocus.com/ppm/en/latest/Help/Content/SA/InstallAdmin/102150_InstallAdmin_Install.htm

The only difference between the GUI installer and the command line installer is that the GUI will ask you to run some commands if it finds some grants are missing - but otherwise the grants you need for PPM user are the same.

Also, a GUI is not needed if you need some interaction during upgrade - you can get the same interactions with a console mode install/upgrade if that's what you're after.

Please clarify what you're looking for here.

Commander
Commander

Hi Etienne, 

Thank you for the detailed response.

I understand that the grants needed for PPM DB user are the same in GUI installer and command line installer mode .

The issue am facing during the console mode install:

  • I cannot use an existing user as PPM DB user.
  • system user is providing the required grants to PPM DB user during the installation. 

where as in GUI mode Install : 

  • I can use an existing user.
  • all the required grants to PPM DB user can be granted before the installation.

or is there any workaround to use an existing PPM DB User ?

Micro Focus Expert
Micro Focus Expert
Status changed to: Waiting for Votes

I've edited the Idea title to better reflect the fact that this is about being able to reuse an existing DB User upon new PPM install (9.62+)

On a related note, I've been informed by some other members of R&D that they're considering extracting the part of DB script required to be run by SYS from the rest of the installation script, so that you could pass the smaller "SYS" specific script to  your DBAs to review & run (which would create the PPM DB user and grant it the proper priviledges), and then run the PPM Installation while not requiring to log as SYS DB user. 

Is that the reason of your request to allow to use an existing PPM DB User created by your DBAs instead of getting PPM to install with SYS Priviledges? If that is the case, then we may already be working on it.

Thanks,

Etienne.

Micro Focus Expert
Micro Focus Expert
Status changed to: Delivered

Hi,

PPM 9.63 has just been released and it includes (again) the Installation GUI where you can pick an existing DB User for installation. 

Note that for PPM 9.63 (as well as 9.62), if you're installing PPM you can directly install this version. You don't have to install 9.60 first and then upgrade like it was the case for 9.61 or any previous minor-minor PPM versions.

Commander
Commander

Thankyou Etienne. This helps a lot.

 

The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.