Please tell me how to create using DB

vishucamunda · October 29, 2019, 12:56pm

I want to create a user using DB and not sure what are the entries i need to make for admin access similar to user demo

Can someone please tell me

Vish

etp · October 29, 2019, 4:08pm

Could you explain your issue/query? Create a user in which Db? Are you referring to native users in Camunda and how to control Authorizations for the users?

vishucamunda · October 30, 2019, 8:07am

i did some changes in the Authorization using cockpit and now i am not able to login back to cockpit so was wandering if i can either create a new user similar to default user demo or make some changes to existing user in database . i want to login back to cockpit which i am not able to

vish

etp · October 30, 2019, 10:09am

You can probably have a look at the Engine table ACT_RU_AUTHORIZATION and probably try changing the PERMS_ value.
For example, for the instance I use, I can see that the for RESOURCE_TYPE_ 0 to 18 and RESOURCE_ID_ * the PERMS_ value is 2147483647 in this table.

PS: Try at you own risk. I have not tried this out

Ingo_Richtsmeier · October 31, 2019, 11:21am

Hi @vishucamunda,

have a look at the DemoDataGenerator of the invoice example:

github.com

camunda/camunda-bpm-platform/blob/master/examples/invoice/src/main/java/org/camunda/bpm/example/invoice/DemoDataGenerator.java

/*
 * Copyright Camunda Services GmbH and/or licensed to Camunda Services GmbH
 * under one or more contributor license agreements. See the NOTICE file
 * distributed with this work for additional information regarding copyright
 * ownership. Camunda licenses this file to you under the Apache License,
 * Version 2.0; you may not use this file except in compliance with the License.
 * You may obtain a copy of the License at
 *
 *     http://www.apache.org/licenses/LICENSE-2.0
 *
 * Unless required by applicable law or agreed to in writing, software
 * distributed under the License is distributed on an "AS IS" BASIS,
 * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
 * See the License for the specific language governing permissions and
 * limitations under the License.
 */
package org.camunda.bpm.example.invoice;

import static org.camunda.bpm.engine.authorization.Authorization.ANY;
import static org.camunda.bpm.engine.authorization.Authorization.AUTH_TYPE_GRANT;

This file has been truncated. show original

The demo user is created here.

Hope this helps, Ingo

system · January 30, 2024, 12:00pm