[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.comments powered by Disqus