Hi Yakov,

Security for SQL Server involves getting into the server and permissions for
server administration functions as well as getting into the databases on
servers and permissions for objects within databases.

I have recently completed a 4-part series of articles on SQL Server security
for SQL Server Magazine.  The first article is available on the web without
restriction.  Its URL is
http://www.sqlmag.com/Articles/Index.cfm?ArticleID=15666.  The other three
articles will come off restricted access over the next three months.  If you
already have a subscription, you can access them immediately.  Just look
under authors for my most recent article.

My second treatment of SQL Server security appears in Appendix A of
Professional SQL Server Development with Access 2000.  This book is by Wrox
Press, and it therefore benefits from their great editorial work.  If you
are just starting out with SQL Server security, it is highly likely that you
will find it useful.  You can learn more about the book from
http://www.programmingmsaccess.com/thebook/#PSSD.

I hope this reply helps.

Rick Dobson
www.programmingmsaccess.com
www.cabinc.net
rickd@c... <mailto:rickd@c...>


Subject: SECURITY system on database level
From: "Yakov Shlafman" <yakov_shlafman@p...>
Date: Fri, 23 Mar 2001 14:19:48 -0500
X-Message-Number: 1

Hi,
I want to build a new SECURITY system on database level with different
levels of securities:
position, granted, applications and enforce the security.
Any books, any comments.

Thanks in advance
Yakov