Windows Sharepoint Services incidentally inside permissions on Lists table with tp_ACL

re: Windows Sharepoint Services incidentally inside permissions on Lists table with tp_ACL

Syed Ali Abbas — Tue, 20 May 2008 11:45:05 GMT

Dear Paolo,

Thanks for bridging gap between newer and experienced peoples...definitely you are doing great job!!!.

I want to know some thing about SharePoint customization, that if i customize SharePoint List web part and create my own web part connected with external database. In this case, i think we compromise some basic features of SharePoint like Searching and access control over content saved in external database. i need your opinion as well as others who want to share their experience with me.

Thanks & Regards,

Ali Abbas

Windows Sharepoint Services incidentally inside permissions on Lists table with tp_ACL

Tue, 27 Nov 2007 11:30:06 GMT

Pingback from Windows Sharepoint Services incidentally inside permissions on Lists table with tp_ACL

re: Windows Sharepoint Services incidentally inside permissions on Lists table with tp_ACL

Christoff — Wed, 11 Jul 2007 04:59:00 GMT

Morning Paolo,

Thanks for an interresting article!!! wonder if you can assist me.. I need to create custom Groups in Sharepoint.. but through a webpart.. When the Site First load it should check if the groups(Custom) are already created if not if should create them=. Of which all the groups should have contributor rights..( 5 + 1 Admin Groups) ..Thus deleting the other groups. But the Admin Name should be change to some other title... I could go the Object route.. or should I go the SQL route?...See

aspalliance.com/articleViewer.aspx

Christoff

re: Windows Sharepoint Services incidentally inside permissions on Lists table with tp_ACL

Romeo Pruno — Thu, 25 Aug 2005 20:02:00 GMT

Sometimes, I have to access directly to WSS db for solve a WSS structure problem, with a personal work-around :-) Sure! is very difficult and dangerous for programmer. Anyway an example occur when I have necessity to share data between different sites.In this situation a don't can use a webpart connection, because this solution don't permit a full control in my WSS sites! I must modify part of a record into MSSQL DB for "link" an other list/Document libraries! For more information, please see at http://blogs.devleap.com/romeopruno/archive/2005/06/09/3933.aspx

re: Windows Sharepoint Services incidentally inside permissions on Lists table with tp_ACL

Paolo Pialorsi — Thu, 25 Aug 2005 10:24:00 GMT

Marco,
you're absolutely right, as you can see also from my last red caveat! :-)
Anyway in my situation I've got the customer explicit request to make it run "faster" even if in the future may be we'll have to rewrite/review that little piece of implementation.
Consider that I'm using the ACL field just to read and not to write any kind of information.
Thanks for your comment and see you at WPC :-).

Paolo

re: Windows Sharepoint Services incidentally inside permissions on Lists table with tp_ACL

Marco Bellinaso — Thu, 25 Aug 2005 10:01:00 GMT

Thanks for the info Paolo, nice and interesting discovery! :-)
We did something similar in our own portal solution, with regards to ACL storage, for performance and security reasons.

BTW, accessing SharePoint's DB is a bad thing in general, accessing the security info stored in those DB is even worse :-) I understand that there are situations where it might be necessary, but I'd try to find some alternative anyway, even a less elegant/simple/performant way...that's because if you tell your client you're using some undocumented and absolutely unsupported (by MS) hack, they are not going to like it at all, and may even force you to change the implementation. It depends on the specific project and client of course. For the finance project we've worked on in the past months, that surely coulnd't get accepted :-(
I'm sure you know this kind of situations :-

Ciao