Re: [cobalt-users] [Off Topic] - phpMyAdmin - mySQL Privileges

[jens@xxxxxxxxxxxxxxxxxxxx (Jens Kristian Søgaard)]

David <david_dean@xxxxxxx> writes:

> What privileges do most of my Cobalt friends allow their users when setting up
> a db/users that's only accessed via phpMyAdmin?
> I've been setting up my users with the following (but I'm still learning from
> DuBois), is this adequate, any suggestions?
> msql>GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP

This isn't really adequate. Normally you would also give your users
these privileges:

        ALTER: Allows you to alter an already existing table (change
               it's structure)

        INDEX: Allows you to create and delete indexes.

        REFERENCES: As this is MySQL it really doesn't matter, but it
                    could in the future.

Depending on your temper, you could also grant them grant
access (sic!). I.e. the abibility to pass on any of their privileges
to other users.

        
-- 
Jens Kristian Søgaard, Mermaid Consulting I/S,
jens@xxxxxxxxxxxxxxxxxxxx,
http://www.mermaidconsulting.com/