MySQL Forums
Forum List  »  Newbie

Deleting user paradox!
Posted by: Farhang Saharkhiz
Date: August 16, 2004 06:57AM

Deleting user paradox!

Suppose in a LAN we have two applications with two MySQL Database located in a certain uniqe server in the LAN.
Each application manage its users.
Consider these terms as follow:

APPLICATION1 creates USER1 with DATABASE1 privilege from the HOST1.
APPLICATION2 creates USER1 (the same USER1 in application1) with DATABASE2 privilege from the HOST1.
(consider a user from a pc wants to work with two MySQL database applications).

Now, APPLICATION1 wants to delete USER1. It may at first execute:
"revoke select on DATABASE1.* from USER1@HOST1" to delete correspondent USER1 record from Mysql.db table.

Then it may execute: "delete from MySQL.user where user='USER1' AND host='HOST1'" to delete record from mysql.user table.

By now, there's no USER1 available to APPLICATION2.

In general, I think if we have the same user from the same host (one PC) working with many databases, then deleting a user from one application may couse unkown user error on other application.


Many thanks for your review and comments.



Options: ReplyQuote


Subject
Written By
Posted
Deleting user paradox!
August 16, 2004 06:57AM
August 16, 2004 10:56AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.