Will the user need to enter the password or will it be enabled when a user connects to the database, without requiring the user to specify the roles' passwords.

Thanks