Hello,
Is it possible for a MySQL connection to request a downgrade in privileges?
What I'd like to be able to do is create one database user account for a
database application with read and write privileges to the tables, but if
an application user logs in who only has read access, then to
What you describe is how I have it set up today. My thoughts on the matter
are that it makes more sense to maintain a single SQL user account for the
application with on password to manage, rather than two or three or four,
and then allow that SQL user, when the connection is made, what
[EMAIL PROTECTED] wrote on 10/12/2005 10:46:46 AM:
You are correct in that each mysql user account only has one set of
permissions. Your application talks to the database and it may only
need one login. One login = one set of permissions. When I am
designing a web-based application, I
Hello,
I am running mysql version 4.1.7 on SuSE professional 9.1.
I have a MyISAM table which I use for syslog messages. This table gets
about 40-70 inserts a second with peaks of over 400 inserts a second. I am
using INSERT DELAYED for all inserts, and only one thread of my application
has
I see the expected behavior from INSERT DELAYED, the server returns right
away and a new delayed thread gets created. I have noticed that my
application's internal queue flushes significantly faster with INSERT
DELAYED than it did with just INSERT, as expected.
Andrew