How to configure sqlum for K2 blackpearl 4.5

K2 blackpearl 4.5 is the same as earlier versions. In addition to supporting ad, it also supports SQL users.

The configuration is actually very simple. You only need to execute the following SQL statement.

 

Insert   Into   [ K2hostserver ] . [ DBO ] . [ Securitylabels ]
( [ Securitylabelid ]
, [ Securitylabelname ]
, [ Authsecurityproviderid ]
, [ Authinit ]
, [ Rolesecurityproviderid ]
, [ Roleinit ]
, [ Defaultlabel ] )
Values
( ' 8e8d5221-ee89-4cd7-99213fcfcdf64abdb ' ,
' K2sql ' ,
' Fc1848e6-23f5-49d8-8c48-9f7b197c80b7 ' ,
' <Authinit> <init> k2-demo, k2sqlum </init> <login/> <implementation Assembly = "sqlum, version = 4.0.0.0, culture = neutral, publickeytoken = 16a2c5aaaa1b130d"
Type = "sqlum. k2usermanager"/> </authinit> ' ,
' Fc1848e6-23f5-49d8-8c48-9f7b197c80b7 ' ,
' <Roleprovider> <init> k2-demo, k2sqlum </init> <login/> <implementation Assembly = "sqlum, version = 4.0.0.0, culture = neutral, publickeytoken = 16a2c5aaaa1b130d "type =" sqlum. k2usermanager "/> </roleprovider> ' ,
' 0 '
)

Where the k2-demo is the server name.

In fact, this SQL statement adds two records to the securitylabels table in the K2 host server database.

After configuring this, you can add users to SQL management studio. You only need to execute the "createuser" Stored Procedure in the k2sqlum database.

After adding a user, you can authorize the new user under server rights in the workspace.