Here's a unique situation, I'm the DBA and my developer has limited rights to the database.
What's unique about that? I'm both. I created two LOGINs, one for my position as DBA and the other for me as developer. Both have different permissions based on the job.
This keeps me from 'messing' anything up when I'm doing developing. It also sets the precedence that DBAs and Developers have different access levels.
-SQLBill