Automatic Association Of Users To Roles (Doc ID 2401821.1)

Last updated on SEPTEMBER 27, 2023

Applies to:

Goal

You're setting up the users in production environment. You've used the macro to create the user records. Though we have the need to add a custom role to all of them.
So far you've done this process manually but we would like to know if we can do it using a macro. Due to the number of users doing this manually would be too time consuming.

Steps that we do manually  :
Security Console -> Users -> Edit -> Add Role

You have the same issue for the Regional settings of the users. In dev environment they were created with the country US and we need them to be with Portugal. Is it possible to do it via macro?
 

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.