Thanks
Have a look at Role-Based Security / Defining Security within the Application / Deploying Security Data.
Then you will find a topic about Deploying Security Data Without the DDT.
But if I were you, I would consider getting the DDT too.
I have my husband the DBA to handle the stored procedures
I am pretty comfortable in SQL Server, so I really do not need it. I found the topic and I did run the script. My problem is that when I run the security maintenace form and run it, it populates the tables in the Strataframe database and not my application database. All I want to know is how to make it update the tables in my database and I can't seem to find an answer to that question anywhere.
You will have to script the import procedure to get that info from the SFS tables in the StrataFrame database and then append them to your client's database or to your testing database in you network. So, when you run the application and point it to its database, you will be speaking to the SFS tables in it.
OK - I finally did figure that one out. So I created a simple security based application with one form that called the maintenace form and got an error when I tried to save a new user saying that a solumn in my users table did not exist. So apparently the script provided to generate the tables in my database is not correct
Thanks for the assistance.
Well, I have given up on trying to integrate RBS into my app for now. I have too much stuff to work on so I can take this app live within the next week or so. I can deal with the discrepancies. I have my own set of utility programs that can create a working script (correctly - not like how SQL Server does it ) from a set of tables.
When I have phase 1 finished, I will revisit the RBS integration.
Thanks for all the help