I have a group that has select, insert, update, delete permissions and I have a user in that group that
needs permissions also to drop tables.

does that login need to be aliased to dbo - which is in public -- do I then to give puboic all the other permissions.

Is there a way to just give one login all permissions including dropping tables??

Help!!