To modify privileges for existing users

Issue a GRANT statement without the IDENTIFIED BY clause, for example:

GRANT CONNECT TO jsmith;