How to grant Connect & Create Privilege on current Database in PostgreSQL?
You could use a DO block with dynamic SQL:

do 
$$ 
begin
  execute format('grant create, connect on database %I to %I', current_database(), 'some_user');
end;
$$;