I started my database by using a copy of the Strataframe Example database which had the Security tables.  I open the Security Dialog box through code (see below).  The editor allows me to add/edit users and roles, but not permissions.  What is wrong?

Program.cs Code:

System.Data.SqlClient.SqlConnectionStringBuilder builder = new System.Data.SqlClient.SqlConnectionStringBuilder();

builder.DataSource = "1LPJPAGLEY\\SQLEXPRESS";

builder.InitialCatalog = "CEI";

builder.UserID = "sa";

builder.Password = "access";

DataLayer.DataSources.Add(new SqlDataSourceItem("", builder.ConnectionString));

//Set the data source key for the security tables

SecurityBasics.SecurityDataSourceKey = "";

 

Form Code:

MicroFour.StrataFrame.Security.SecurityDialog frm = new MicroFour.StrataFrame.Security.SecurityDialog();

frm.ShowDialog();

Thanks,

Jeff

I have not deployed the production database yet.  I am still working on the developing the database.  However, I have not used the DDT.  So what you are saying is once I develop my production database then I can add the security tables and their records from the Strataframe database to my production database using the DDT, correct?  What if I have two or more projects in the RBS Editor system for different development applications I am working on.  Will the DDT enable me to deploy the security tables and only the records associated with the security project which is setup for the application I am deploying? 

Jeff

Working backwards, if you have two projects then you need to create 2 security projects.  Once for each, so if you set this up correctly, then yes, you can distinguish between each project and deploy them appropriately.  When you create the permissions, then you just pop over to the DDT, repackage, then deploy data only (after the tables have been created) to update your database with the appropriate permissions.