Everyone has a personal folder in the Oracle Analytics catalog, located under My Folders, where they can store content for personal use. The name of your personal folder is based on the username that you use to log into Oracle Analytics Cloud. If usernames change for any reason, the administrator must update the usernames inside the Oracle Analytics catalog, so users maintain access to their folders. When login usernames and personal folder names get out of sync, users can’t access content that they saved in their personal folder.

Let’s look at a common scenario where usernames might change. Customers who migrate to Oracle Analytics Cloud from other environments often prefer to use email addresses to log in instead of a short name.

  • Problem: If the administrator doesn’t update the usernames in the catalog, users lose access to personal content migrated to Oracle Analytics Cloud. A new folder is created for each user under My Folders (based on the new username).
  • Solution: Rename existing user folders in the catalog. This way, users maintain access to their migrated content, and any new content they create gets saved to the same folder.

How to Rename Multiple Users Using the Catalog Command Line Utility (runcat)

Administrators can change multiple usernames at once using the runcat command line utility.

runcat.sh -cmd renameAccounts

     -old <old name{;;old name}>

     -new <new name{;;new name}>

     -online <Connect URL>

     -credentials <Login text file>

For example:

./runcat.sh -cmd renameAccounts -old user1;;user2;;user3;;user4 -new newUser1;;newUser2;;newUser3;;newUser4 -online https://OACinstance.ocp.oraclecloud.com/analytics-ws -credentials boot.txt

In this example, boot.txt is a text file that contains administrator login credentials for Oracle Analytics Cloud.

Syntax for boot.txt

login=AdminUser

pwd=password

NOTE – One should not rename user folder from from Oracle Analytic Classic or Catalog Manager. 

For More Information

•          Catalog Manager UI: For more information, see Perform Advanced Catalog Management.

•          Catalog Manager Command Line: For command line help, run the command: runcat.cmd -cmd renameAccounts -help