Is there a way to disable SET PASSWORD for selected users

I would like to prevent users from changing their passwords unless they hav=
e grant permission. Is this possible?

We have an set of stored procedures for managing users/databases for a sing=
le signon project that we are working on. The problem is if a user connect=
s directly to the database using the client and changes their password usin=
g SET PASSWORD=3D PASSWORD('their new password'), it breaks the single sign=
on. =20

Thanks,=20

Gary=

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=3Dgcdmg-mysql-2@m.gmane.o rg