StrataFrame Forum / StrataFrame Application Framework / Role Based Security / How do I determine the SF security project ID via code? / Latest PostsInstantForum.NET v4.1.4StrataFrame Forumhttp://forum.strataframe.net/forum@strataframe.netTue, 02 Dec 2008 16:36:25 GMT20RE: How do I determine the SF security project ID via code?http://forum.strataframe.net/Topic6186-21-1.aspxAh. That's important to note. I took a look at the script that can be used to create the security tables (download link from security help file) to try to wrap my head around this a bit better and I noticed that some tables that have the sproj_pk column (prefixed of course) have a default of 0 and some don't (SFSRoles, SFSPermissions and SFSRestrictions). Is the script wrong or are these columns updated otherwise?<br><br>Thu, 25 Jan 2007 11:04:15 GMTGreg McGuffeyRE: How do I determine the SF security project ID via code?http://forum.strataframe.net/Topic6186-21-1.aspxYou can call the FillAll() method on the SFSRolesBO object and pass it a project pk of 0. At runtime, there are no project pks... the SFSProjects table does not exist in the runtime database, and the tables are assumed to have records from only one project.Thu, 25 Jan 2007 09:12:49 GMTBen ChaseHow do I determine the SF security project ID via code?http://forum.strataframe.net/Topic6186-21-1.aspxI need to load the an instance of the SFSRolesBO with all the roles from the security project used by the application. While I can look at the table and figure out what the ID it, it would be much better to just reference the ID used by the security system. How do I do that?<br>Wed, 24 Jan 2007 15:38:39 GMTGreg McGuffey