Use this statement to grant connection permission for a user.
GRANT CONNECT TO userid. [IDENTIFIED BY password]