Hi,

I am trying to evaluate the Role Based Security but am struggling to get it up and running. I've read through the Deploying Security Data and downloaded the script as directed:

"Download the Script - Click here to download the script.  Once downloaded, extract the .sql file from the Zip."

But when I try to use the Role based Security Function in VS and add new I keep getting an error stating:

  Invalid object name 'dbo.SFSProjects'.

Which is correct as that table doesnt exist in the script.

I have tried a few things and got a bit further only to find a different problem so I have started again.

Can anyone point me in the right direction?

Thanks

Jon

Sorry it should say without DDT, as I am not using the DDT.

Hey its getting late over here in the UK!!

Jon,



The SFSProjects tables is in the StrataFrame database, thus it isn't part of the RBS deployment script. This is used to allow you to develop security for multiple projects.



The most likely issue, I'd think, would be that you don't have the connection to the StrataFrame database setup properly. If you go to the StrataFrame menu in VS and then to the Database Connection item, make sure that the connection is set and pointing to a valid StrataFrame database.



Also, I'd only expect that this error would occur if you were attempting to use the security dialog from the StrataFrame menu in VS (though there could be other places this could occur, I just can't think of them ).



BTW, deployment of security data can be...er...exciting without DDT. With DDT it is very easy.

Greg is right on the money.  Let me know if you don't have any luck.