.net - Add users to System.Activities.DurableInstancing roles -
We have a lot of customers connecting to SQL Server using db_datawriter and db_datareader roles We still have no Flexible roles were not.
Now our software uses the new workflow FatAtian firmness store.
- <: it mentioned that we used creates sql script sqlworkflowinstancestoreschema.sql and 3 new roles sqlworkflowinstancestorelogic.sql, which within a database schema
-
System.Activities.DurableInstancing.InstanceStoreUsers
-
System.Activities .DurableInstancing.WorkflowActivationUsers
System.Activities.DurableInstancing
and to enable li> System.Activities.DurableInstancing.InstanceStoreObservers
user db_datawriter
and db_datawriter
roles only get SqlException: < / P>
Execution permission objection The 'CreateLockOwner' database was denied on 'mydatabase', schema 'System.Activities.DurableInstancing'.
This is the software that starts in store.Execute:
Installel Handle = store.CreateInstanceHandle (); Var createOwnerCommand = new CreateWorkflowOwnerCommand {InstanceOwnerMetadata = {{XNWorkflowHostTypePropertyName, New InstanceValue (XNWorkflowHostTypeIdentifierName)}}}; View Instance View = Store. Execute (Build Handle, On Commander, Timespain. Foamseconds (30));
I've already tried this:
EXEC sp_addrolemember @rolename = 'System.Activities.DurableInstancing.InstanceStoreObservers', @membername =' Db_datawriter '; EXEC sp_addrolemember @rolename = 'System. Methodology DurableInstancing.InstanceStoreUsers', @membername = 'db_datawriter'; EXEC sp_addrolemember @rolename = 'System. Functional features. DurableInstancing.WorkflowActivationUsers', @membername = 'db_datawriter'; Error message with: Error 15405: Special Principal 'db_datawriter' can not be used. Question:
Is there any other possibility that I ignore permissions for a script with these roles, without the login name Know about
In general, you do not use users' right to store stores. Users of your application use the firmware through the workflow engine and the engine has access to the store.
Is there a special scenario where you need access to the store directly?
Comments
Post a Comment