RE: Keeping separate databases?

["Jason Monroe \"JC\"" <monroe () nas nasa gov>]

On Tue, 2004-03-16 at 09:28, Jason Haar wrote:
>   Wont that be messed up if I just move the DB to a new
> > directory? Thanks
>
> Nope. Most standalone SQL apps put all their data into tables in one
> database - so just renaming the Unix dir that defines the name of the
> database renames the database.
> Just ensure you do it when the SQL server is DOWN - doing it while it's
> writing to it may not be a good look...
> Jason

Ok this is all well and good, but in most cases people are using ACID or
some other GUI and try to employ least privilege as much as possible. So
they move the name of the MySQL db by hand, now the MySQL perms on the
new archive DB don't exist and only MySQL-root can connect. Working
under the construct where the GUI doesn't connect as MySQL-root have any
of you guys created some type of automated way of managing permissions
on these potentially dynamically created databases?

The other Jason 
> -------------------------------------------------------
> This SF.Net email is sponsored by: IBM Linux Tutorials
> Free Linux tutorial presented by Daniel Robbins, President and CEO of
> GenToo technologies. Learn everything from fundamentals to system
> administration.http://ads.osdn.com/?ad_id=1470&alloc_id=3638&op=click
> _______________________________________________
> Snort-users mailing list
> Snort-users () lists sourceforge net
> Go to this URL to change user options or unsubscribe:
> https://lists.sourceforge.net/lists/listinfo/snort-users
> Snort-users list archive:
> http://www.geocrawler.com/redir-sf.php3?list=snort-users


-------------------------------------------------------
This SF.Net email is sponsored by: IBM Linux Tutorials
Free Linux tutorial presented by Daniel Robbins, President and CEO of
GenToo technologies. Learn everything from fundamentals to system
administration.http://ads.osdn.com/?ad_id=1470&alloc_id=3638&op=click
_______________________________________________
Snort-users mailing list
Snort-users () lists sourceforge net
Go to this URL to change user options or unsubscribe:
https://lists.sourceforge.net/lists/listinfo/snort-users
Snort-users list archive:
http://www.geocrawler.com/redir-sf.php3?list=snort-users