Hello,
We try to collecte a business units from a csv file using a "custom workflow", each business unit has many Business Owners. For that, we want add their owners like a other Business Owners, For the moment we add the business units in t_av_business_units_versions and t_av_business_units tables. but we do not found where we add the other business units.
How can i add Other Business Owners to a business unit using SQL?
Best Regards.
All attributes of type ACL are stored in the table T_AV_SECURITY_VALUES. The format looks like the below (I added three users as other business owners from the UI).
Thank you Mostafa, now i can add other business owners, but i noticed that user added using SQL has not the following entitlements:
Now i have a new question, how can i add the entitlements using SQL?
Thank you.
Thank you Mostafa, i found how to add the entitlements using SQL.
I recapulate: to add other business owners to a Business unit, you need to have a user OID, UseriD and the Business unit Oid:
At first add the user like a other business owner for the Business unit:
insert into T_AV_SECURITY_VALUES values ('BU_OBO' ,<user OID> ,'user', <BU OID>)
Then add the entitlements to the user:
INSERT INTO T_AV_SECURITY_CONTEXT_USERS VALUES (<userId>,'Rule Set','Business Unit Other Business Owner');
INSERT INTO T_AV_SECURITY_CONTEXT_USERS VALUES (<userId>,'User','Business Unit Other Business Owner');
INSERT INTO T_AV_SECURITY_CONTEXT_USERS VALUES (<userId>,'Application','Business Unit Other Business Owner');
INSERT INTO T_AV_SECURITY_CONTEXT_USERS VALUES (<userId>,'Data Resource Set','Business Unit Other Business Owner');
INSERT INTO T_AV_SECURITY_CONTEXT_USERS VALUES (<userId>,'Directory','Business Unit Other Business Owner');
INSERT INTO T_AV_SECURITY_CONTEXT_USERS VALUES (<userId>,'Role Set','Business Unit Other Business Owner');
Best regards
Thank you Mostafa, i found how to add the entitlements using SQL.
I recapulate: to add other business owners to a Business unit, you need to have a user OID, UseriD and the Business unit Oid:
At first add the user like a other business owner for the Business unit:
insert into T_AV_SECURITY_VALUES values ('BU_OBO' ,<user OID> ,'user', <BU OID>)
Then add the entitlements to the user:
INSERT INTO T_AV_SECURITY_CONTEXT_USERS VALUES (<userId>,'Rule Set','Business Unit Other Business Owner');
INSERT INTO T_AV_SECURITY_CONTEXT_USERS VALUES (<userId>,'User','Business Unit Other Business Owner');
INSERT INTO T_AV_SECURITY_CONTEXT_USERS VALUES (<userId>,'Application','Business Unit Other Business Owner');
INSERT INTO T_AV_SECURITY_CONTEXT_USERS VALUES (<userId>,'Data Resource Set','Business Unit Other Business Owner');
INSERT INTO T_AV_SECURITY_CONTEXT_USERS VALUES (<userId>,'Directory','Business Unit Other Business Owner');
INSERT INTO T_AV_SECURITY_CONTEXT_USERS VALUES (<userId>,'Role Set','Business Unit Other Business Owner');
Best regards