Yes, I can do it with a middle tier, but currently my app is a simple 2-tier and introducing a middle-tier just to do that looks excessive...
On Sun, 21 Dec 2003 18:40:40 -0330 "jamie murray" <[EMAIL PROTECTED]> wrote: > What about creating a flat file on the middle tier from the database system > tables that the clients can view with your gui or web page. > Only things is keeping the file in sync with the system tables. But access > will be faster to the flat file and no security risks > because there won't even be a connection to the database from the client > when viewing the file. > > > ----- Original Message ----- > From: "Plinio Conti" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Sunday, December 21, 2003 5:55 PM > Subject: Quering user privileges > > > > > > Is there a way to query the privileges of current user if he hasn't the > rights to read the mysql system tables (user, db, hosts, etc..) > > > > I mean, I CAN'T give a standard user the chance of read "system tables"! > > But my client app wants to know if the current user has (for example) the > rights to write on table xxx, because if not, I don't want to let him try > and fail, I want to disable the updates in advance. > > > > Tahnk you, > > Plinio > > > > > > > > -- > > MySQL General Mailing List > > For list archives: http://lists.mysql.com/mysql > > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > > > > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
