[ale] [OT] MySQL privileges question.....

Kevin O'Neill Stoll kevinostoll at yahoo.com
Fri Dec 19 09:01:53 EST 2003


I realize that you have probably already read this document
but if not give it a browse :

http://www.mysql.com/doc/en/Privileges.html

About half way through the doc it talks about the order in
which it applies the user,db,host permissions and which
takes presidence.



--- Keith Morris <graphicsguy at charter.net> wrote:
> Hi all.
> 
> I'm trying to create mysql users who have near root
> privileges: 
> SELECT,INSERT, UPDATE,DELETE, CREATE, DROP, INDEX, ALTER,
> REFERENCES, 
> SHOW DATABASES
> 
> The problem is, I want to give them these privileges ONLY
> on the 
> databases that they create, not any other's databases and
> I want this to 
> happen automatically so I don't have to police the
> databases and be 
> setting permissions all the time.
> 
> When I explicity deny the user priviliges in the mysql.db
> table, and run 
> the flush privileges command....no effect.  It seems as
> if the 
> mysql.user privileges are overriding the mysql.db
> privilegs... is this 
> right?
> 
> I've been trying to find reference to anything about
> database ownership 
> in MySQL but have not had much luck.
> 
> I would appreciate any information you might have.
> 
> Thanks in advance.
> 
> Keith Morris
> 
> 
> _______________________________________________
> Ale mailing list
> Ale at ale.org
> http://www.ale.org/mailman/listinfo/ale


=====
Kevin Stoll
http://kevinstoll.com/

OpenSource Software...FREE!
Angering Bill Gates...priceless.
============================================================

__________________________________
Do you Yahoo!?
New Yahoo! Photos - easier uploading and sharing.
http://photos.yahoo.com/



More information about the Ale mailing list