Hi all

I was wondering is it possible to have multiple databases set up so an administrator could login once to admin all databases with out having to login to each one seperately. I want to set up ten databases but it would be a nightmare constantly logging in. Have any of you seasoned veterans tried this before, or is it a simple thing and Im missing something, Im kind of hoping thats the case. Id like to hear any thoughts on the subject before start blindly experimenting, I havnt set up that many before but Ill try anything at least once. Thanks in advance.

jollyroger

check out LoisC's unofficial FAQ (see any of her posts for URL) to see if there's answer for this.

My suggestion would be to share the same password & auth files/directories for all 10 db's.

In the worst case you could use links to switch back and forth...

Example on the "home or main" page of each db do something like:

if ($per_admin) {
print qq|
<a href="./2nd_db.cgi?user=admin&pw=foo&login=1">Switch to DB 2</a>
|;
}

and repeat as necessary for db's 3-10.

Of course the syntax is not correct, you have to do some experimenting to make it work exactly right.

Thanks for the tip, I checked out LoisC's site and some one else had suggested the exact same thing you did, which is exactly the simple solution I was looking for.

thanks again