Geek Answers Handbook

SQL Server Schema Considerations

I am developing a new database for the application. I would like to remember security from the very beginning (which should be the norm!). Has anyone received a link to a resource describing the best way to use circuits for good security?

Using schemas, I mean not just resetting everything according to the dbo schema by default. Surely there is a scheme of best practices? Can't find it if there is ...

+6
security sql sql-server schema
source share
1 answer

Security Enhancements in SQL Server 2005: Schema
http://www.sql-server-performance.com/articles/dba/authorization_2005_p1.aspx

SQL Server Best Practices: Custom Schemas
http://blogs.msdn.com/buckwoody/archive/2009/06/18/sql-server-best-practices-user-defined-schemas.aspx

... And the required MSDN link:
http://msdn.microsoft.com/en-us/library/ms190387.aspx

+8
source share

More articles:


All Articles