HDL Tutorial : How to attach roles with User Account Automatically with the help of HDL in Oracle Cloud : User Roles Assignment HDL script in Oracle Cloud

HDL Tutorial : How to attach roles with User Account Automatically with the help of HDL in Oracle Cloud : User Roles Assignment HDL script in Oracle Cloud

In this post , We will discuss about HDL Script to Assign Oracle cloud roles with User Accounts automatically. If we have the User Accounts already exists in Oracle cloud then we can use this HDL script to assign Oracle cloud roles. If we also want to create the User accounts automatically then you can refer my previous post Employee User account creation through HDL.

 

We should have the Role Name and Code before assigning the roles with the cloud User accounts automatically through HDL. Oracle cloud has given us the metadata to support User create and roles assignment automatically with the help of HDL tool. 

 

Here below I am sharing the HDL Script/Metadata to attach roles with User Account Automatically with the help of HDL in Oracle Cloud

 

Steps to attach roles with User Account Automatically with the help of HDL in Oracle Cloud

Step1:- This is the below HDL metadata helps to create the User Account for Cloud Employees. Employee should be created first in the cloud.

 

METADATA|UserRole|PersonNumber|RoleCommonName|AddRemoveRole

 

 Step2:- To prepare the Data to attach roles with User Account, We need to prepare the data in this below form.

 

 The first line MetaData which will always be constant and from line second , we need to enter the roles information's which we want to assign with Oracle User accounts in Oracle Cloud Application

 

METADATA|UserRole|PersonNumber|RoleCommonName|AddRemoveRole
MERGE|UserRole|25545454|PAYABLES_MANAGER|ADD

This is the Sample HDL script to assign roles with User Accounts from HDL Automatically.

Once this You have prepared the Data in this format , you need to save this Data in the .Dat extension file. This HDL file names 'User.dat'.

Here below is the sample file having Roles Information for the User account.

Step5:- After this we need to put this File User ZIP folder.

 

 

 Step6:- Once we have prepared the Zip files then we need to import these file in Oracle cloud with the help of HDL tool as below. Once the zip file have been prepared. Then We need to go Data Exchange

 Step7:-Then Data Exchange ==> HCM Data Loader ==> Import and Load Data

Import the User zip file in cloud application and check the results after that.

 

 

 HDL Tutorial : How to attach roles with User Account Automatically with the help of HDL in Oracle Cloud : User Roles Assignment HDL script in Oracle Cloud