• SharePoint

[via Paolo Pialorsi]

Stay out of the SharePoint database! With that being said, I stumbed across Paolo’s post “Windows Sharepoint Services incidentally inside permissions on Lists table with tp_ACL”.  He digs into the permissions DB table for WSS lists and disects the contents.  Interesting read.

For the record, no, I don’t suggest writing apps that touch the SharePoint database… you’re just playing with fire.  Playing with the site def. files or list templates that come OOTB isn’t as much of a big deal because it’s easy to replicate your changes if MSFT decides to update then in a future service pack.  As it goes for SharePoint, the same practices carry over to MCMS as mentioned previously. 

However… learning how something works under the covers can make you a stronger developer.  I’ll admit that I’ve poked around the SharePoint (WSS & SPS) and MCMS databases, BUT, I’ve done this ONLY in a development environment and I don’t write apps that take advantage of this method… frankly, it’s easier to work with the API in my mind.

» Windows Sharepoint Services incidentally inside permissions on Lists table with tp_ACL