yes it is a nuisance, but a good one in my opinion. If Oracle had this ability it would get abused and people would end up with way more priveleges than they need just because it was quicker to grant all rather than actually work out what was needed