You can grant access to a database for a user within your account by going to the database settings page. Open the database, select the "Database Settings" option on the left hand side of the page. Find the Access Control section and select the name of the user to add. Click "Add User".
This change is immediate.