Re: Database Administration

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On 21 September 2010 11:48, Tom Barrett <tom@xxxxxxxxxxxxxxx> wrote:
> Hi
>
> I need to build a custom client management app, which will build and manage
> a database per client. This means that on top of the usual sql crud, it
> needs to be able to create databases, add/edit/delete database users, create
> tables.
>
> Is there a way for me to do this nicely as PHP solution? am I better off
> incorporating non PHP pieces into this (e.g. shell)? or should I leave the
> admin tasks (e.g. database creation) as a 'normal' administrative task
> (commandline/webmin/watever)?
>

Seeing as all the "extra" stuff you need is just plain sql commands, I
don't see the problem as such. You just need to make sure access to
the tool is done right (i.e. a user that can create/destroy databases
needs to be aware of this and you need to restrict the access to those
specific persons).

Regards
Peter

-- 
<hype>
WWW: http://plphp.dk / http://plind.dk
LinkedIn: http://www.linkedin.com/in/plind
BeWelcome/Couchsurfing: Fake51
Twitter: http://twitter.com/kafe15
</hype>

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



[Index of Archives]     [PHP Home]     [Apache Users]     [PHP on Windows]     [Kernel Newbies]     [PHP Install]     [PHP Classes]     [Pear]     [Postgresql]     [Postgresql PHP]     [PHP on Windows]     [PHP Database Programming]     [PHP SOAP]

  Powered by Linux