If you want better answers to your questions, you might want to consider rephrasing your topic titles and initial posts. Reframing this situation might have gotten your answer faster and without the judgement you are so obviously mad about.
Also, the solution you like doesn't actually cut out the DBA. It requires the DBA to set up the permission to grant permissions in the first place, which is not what your topic title indicated.
Please understand that this isn't a "your shop must be like my shop" situation. It is literally a "we've seen this question before from people trying to hack the company or cause damage" situation. So our first response to the way you phrased your request (without the small shop context that could have helped) was to prevent security damage. You also made it sound like you aren't the DBA, which is another red flag.
I'm glad you have a solution that works for you, but you need to ensure the people granting these permissions are judicious in their use of them. Small shop or no, giving people access to grant security permissions to whomever they feel like it could potentially be a disaster in the making. So be sure you can trust whomever is getting and giving permissions on that data. Bad actors don't just work for large companies.
Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.