StrataFrame Forum » StrataFrame Application Framework - V1 » Role Based Security » Role Base Security for OracleInstantForum 2017-1 FinalStrataFrame Forumhttp://forum.strataframe.net/StrataFrame ForumSat, 26 Sep 2026 08:26:44 GMT20Role Base Security for Oraclehttp://forum.strataframe.net/FindPost5453.aspxHello<BR>Does anyone has the scripts to create the role base security tables under Oracle? That will save a lot of time rewriting the ones supplied for sql 2005.</P><P>Thanks in advancedTue, 02 Jan 2007 14:00:07 GMTGuillermo VilasRE: Role Base Security for Oraclehttp://forum.strataframe.net/FindPost5507.aspxI haven't created one.&nbsp; Although I will warn you that once the auditing becomes available for the security module, it will be a SQL Server 2005 only feature because the auditing records are stored in XML columns.&nbsp; So, you might consider using SQL Server 2005 Express for just security and Oracle for your application itself... the security tables are referenced very seldomly, and the 4GB limit is definitly big enough to handle 4 million plus users and permissions...Tue, 02 Jan 2007 14:00:07 GMTStrataFrame Team