Not using SA - Then what?

From: Chris Beardsley (clb39@nospam-cornell.edu)
Date: 05/31/02


From: "Chris Beardsley" <clb39@nospam-cornell.edu>
Date: Fri, 31 May 2002 09:00:22 -0400


I have read that people should not be using SA for anything. How then do I
have multiple developers/managers login to enterprise manager etc but have
all the objects owned by dbo (we each have diff NT logins)? If SA is stored
in clear text in some situations, wouldn't all uid/pswrd combo's appear in
clear text?

We have wrestled with people making and therefore owning objects, and
causing headaches in the past...

TIA

Chris