• I mostly used the built-in roles, but because using only teh built-in roles would sometimes mean either splitting data I want to have in one database over two (or more) databases (preventing some highly desirable uses of declarative referential consistency) or giving some logins more privileges than ideally they should have I sometimes made custom roles. In my experience it is rare for a custome role to be common to many databases, so not making the roles the same in every database reduces clutter - and I certainly don't see it as promoting inconsistency.

    Tom