Good one Andy, Very very different one.. 🙂

(I got the answer wrong, what I did is created the user (one query) and just mapped to the database (another query), but in both no role was set. I then logged in as this new user and tried to query the table and it gave permission error and then I executed another query in the admin window for adding role, when I disconnected and connected with new user and checked the output was seen. So I thought of the orphaned option thinking might be role has not been associated.)