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 downgrade the
permission's on the SQL server for the database user to select only for
that connection. I want to be able to give an added level of assurance that
the user will not be able to write to the database even if the application
controls are circumvented. As it is now, I have to create multiple database
users and choose which one to connect to the database with based on the
application users authorization level.


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to