Sunday, February 19, 2012

dbo access

Hi,
We have a sql 2000 machine that we use for our internal
intranet. It houses about 10 applications. Each db need
a user that an application can use. Is it advisable to
make those particular users dbo as they need privs to
create tables, sproc, views etc...
What is the best policy that other dba are using
ThanksPlease review this:
Microsoft SQL Server 2000 SP3 Security Features and Best Practices
http://www.microsoft.com/technet/tr...chnet/prodtechn
ol/sql/maintain/security/sp3sec/default.asp
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.

No comments:

Post a Comment