Ticket #1872 (new enhancement)

Opened 13 months ago

Last modified 13 months ago

Separate accounts for Create-DB, and normal Usage

Reported by: Purodha Owned by: aoneil
Priority: minor Milestone:
Component: CMS - Installer Version:
Severity: medium effort / impact Keywords:
Cc: Hours:

Description

On some shared servers, a higher ranked account, or more privileged access, to the data base server is required, so as to create a new database, while once the data base has been created, normal usage is delegated to a lower ranked account having less rights, especially not the right to create new databases.

On such servers, it might be nice to have two sets of user/password pairs during the installation process, and explicitly state on the install web page that, the "create" user/password is not kept or stored anywhere, while the other is.

Of course, specifying a second user/password should be optional for servers that do not need it.

Also, it would be nice to state on the install page that, a(n empty) data base may already have been created and were simply being used, if it was already there. I tried this, and it worked, but I was not necessarily expecting it to work, since it was not mentioned.

Change History

in reply to: ↑ description   Changed 13 months ago by Purodha

I wrote:

> Also, it would be nice to state on the install page that, a(n empty) data base may already have been created and were simply being used, if it was already there. I tried this, and it worked, but I was not necessarily expecting it to work, since it was not mentioned. <

Apparently, it did not work. There were no data base tables created. The reason may have been that, the given user did not have create right. Due to other errors reported elsewhere, I was as to yet unable to isolate the reason why.

Note: See TracTickets for help on using tickets.