.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 and to enable li> System.Activities.DurableInstancing.InstanceStoreObservers
  • System.Activities.DurableInstancing.InstanceStoreUsers
  • System.Activities .DurableInstancing.WorkflowActivationUsers

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

Popular posts from this blog

c# - SignalR: "Protocol error: Unknown transport." when navigating to hub -

c# - WPF Expander overlay used in ItemsControl -

class - Kivy: how to instantiate a dynamic classes in python -