• sqlservercentral 26319 (1/29/2014)


    ...When I mentioned database roles he stated that it would be too complicated for the developers to get their heads around....

    Sounds like they have ended up with a good DBA and inadequate developers. Or at least a poor impression of the developers. I don't mean to be funny but schemas are easy to understand in principle as is the concept of database roles. Any developer worth their salt would quickly pick up how they can be combined for authentication purposes (if they didn't already know).

    Gaz

    -- Stop your grinnin' and drop your linen...they're everywhere!!!