Deleting Private Database Logins for P6 EPPM

If you no longer need your private database users you can delete them.

To delete private database logins for P6 EPPM:

Go to P6 EPPM <release_level>\database and run databaselogins.bat (with Windows) databaselogins.sh (with UNIX or Linux).
On the Database Connection dialog box:
1. Select the database.
2. Type the user name and password of a privileged database user (for example, privuser). This login should have administrative rights on the database.
3. Enter the connection details for the database.
  For an Oracle Database, enter the host address, host port, and database/instance name specific to your installation. The Port field displays the default port for the database type you selected.
  
  For an Oracle Autonomous Database, enter the location of the unzipped wallet file and the service name.
  
  For a Microsoft SQL Server Database, enter the host address, host port, and database/instance name specific to your installation. The Port field displays the default port for the database type you selected.
4. Click Next.
On the Private Database Logins dialog box:
1. Select the private database user name that you wish to remove.
  Note: You must have at least one private user name for the P6 EPPM database at all times.
2. Click Delete.
  Note: To reverse a change, click Undo. Undo will reverse any changes made during the current session.
3. Click Save.
4. Click OK to exit the Database Logins tool.