security data location?

StrataFrame Forum

Back

security data location?

Author

Message

posted 18 Years Ago

Group: Forum Members
Posts: 10, Visits: 31

I input some data (like users&roles&permissions) using the 'Security Editor' , Where did these data go?

I did not see these data in any of the SFS tables? Please guide.

Also how should I using these data in the application? Thank you.

Yong

Replies

posted 18 Years Ago

Group: Forum Members
Posts: 10, Visits: 31

Trent L. Taylor,

I use the 'Security Editor' to input the security data (User name/role/permission...), all the data go to the design time settings database: StrataFrame

How to change the design time settings? Or say can the ‘Security Editor’ store the security data into some other database?

>>All data at design-time is stored in the StrataFrame database to which you have your design time settings pointed. To deploy your >>Security into you application in the field, you have several options. You can use the DDT (Database Deployment Toolkit) which will make >>short work of it or do it manually.

Trent Taylor

posted 18 Years Ago

Group: StrataFrame Developers
Posts: 6.6K, Visits: 6.9K

First, you have to export the security data to your database. Let's assume your database is named MyDatabase. If you are using the Database Deployment Toolkit, use the deployment package wizard to bring in the security structures and data.

Look at the help topic in the DDT Help for more details: Deployment Data Packages -> Deployment Package Wizard

Once you have created the Deployment Data Packages, you MUST deploy the DDT profile to your SQL Server before the changes and security data are deployed to the "MyDatabase" database in your server. To deploy, click the Deploy To Server button within the DDT.

Be sure to re-create the packages when prompted.

Once this has been completed and you have deployed the data and structures to your server. THEN you can access these settings within your application. If you are using "MyDatabase" or your application database to house the security tables and data, then make sure to set the following value in the InitApplication of your AppMain.vb or Program.cs file:

SecurityBasics.SecurityDataSourceKey = ""

If you are specifying a different data source connection and database for your security to be housed, then let me know and I will post some different code.

At this point you should be able to run your application and properly access the security data.