StrataFrame Forum » StrataFrame Application Framework - V1 » Role Based Security » Does the Security module works on Oracle????

Does the Security module works on Oracle????

Guillermo Vilas — Thu, 04 Jan 2007 10:43:38 GMT

Any help will be appreciated.

RE: Does the Security module works on Oracle????

StrataFrame Team — Thu, 04 Jan 2007 10:43:38 GMT

Yeah, I think it would be the easiest way to implement security. You'll just have to make sure you add both data sources (one for the security connection string to SQL Server, and one for the Oracle connection string). I would recommend leaving the Oracle data source as the default data source (by specifying a data source key of an empty string [""]) and set the data source key for the security data source to something else, like "SecurityDataSourceKey". You'll then need to set the MicroFour.StrataFrame.Security.SecurityBasics.SecurityDataSourceKey property to "SecurityDataSourceKey" to tell SF that the security tables are not in the main database, but to use the other connection string to reach them.

RE: Does the Security module works on Oracle????

Guillermo Vilas — Wed, 03 Jan 2007 21:52:33 GMT

Thanks Ben
The Oracle issue came with my client constraint as this is the database they have. So I Think I will follow the first approach you gave me to handle security within the project.

RE: Does the Security module works on Oracle????

StrataFrame Team — Tue, 02 Jan 2007 14:16:13 GMT

The security module is designed to work with SQL Server 2005, and once the auditing becomes available, it will be SQL Server 2005 only. So, it would probably be the easiest to have a SQL Server 2005 Express db somewhere that has your security tables and use Oracle for your application itself. However, if you have a huge aversion to SQL Server (being an Oracle guy, I'm just saying... :)), you could modify the security module to work with Oracle. You would need to create the tables and views in Oracle and then modify business objects within the SF Security source code and specify the sequences the business objects should use for their primary keys. As long as you get all of the data types matched up, you should be good to go. So, Oracle isn't technically "supported" by the security module, but if you run into any problems once you change the business objects, then let me know and I'm sure I'll be able to come up with something.

RE: Does the Security module works on Oracle????

Guillermo Vilas — Tue, 02 Jan 2007 10:49:25 GMT

Yes, I'm aware of that, this is going to be like "Customers doing employee work", I will wait to see what news are coming after holidays.

RE: Does the Security module works on Oracle????

Ivan George Borges — Thu, 28 Dec 2006 13:41:27 GMT

I see. But tell me something ... what module are you modifying? Are you making changes to the source code? If so, keep in mind that this might get you in a difficult position when they, in the future, make any changes to the source, so you would probably loose your changes once upgraded.

RE: Does the Security module works on Oracle????

Guillermo Vilas — Thu, 28 Dec 2006 12:59:59 GMT

Thanks Ivan
I can't wait to them to begin answering all my questions :P

What it is true is that I already begun to modify the module for Oracle since I don't believe it's fully supported from the test application I've working.

RE: Does the Security module works on Oracle????

Ivan George Borges — Thu, 28 Dec 2006 10:46:08 GMT

Hi Guillermo.

I haven't tried this yet, but wouldn't think it is a problem.

The SF developers will certainly point you in the right direction as soon as they get back next week, I'm sure.

Abraços.