Unable to Bulk Update User Roles: "no privilege from accEngine to execute sql:SELECT DISTINCT a.id FROM SystemUsers" (Doc ID 2730254.1)

Last updated on JUNE 14, 2022

Applies to:

Symptoms

Unable to Bulk Update User Roles in Sites

When calling the following XML element code from a page:

<USERMANAGER.GETUSERFROMNAME USERNAME="'{USER_NAME}" OBJVARNAME="u"/>
<CCUSER.GETSITEROLES NAME="u" SITE="{pubid}" OBJVARNAME="rolelist"/>
<ROLELIST.GETALL NAME="rolelist" VARNAME="roles"/>

The following error is seen in the sites.log:

[wcmint_wcsites] [ERROR] [] [oracle.wcsites.db] [tid: 133] [userId: <anonymous>] [APP: sites] [partition-name: DOMAIN] [tenant-name: GLOBAL] no privilege from accEngine to execute sql:SELECT DISTINCT a.id FROM SystemUsers a WHERE ( (a.username='{USER_NAME}'))
[wcmint_wcsites] [ERROR] [] [oracle.wcsites.db] [tid: 133] [userId: <anonymous>] [APP: sites] [partition-name: DOMAIN] [tenant-name: GLOBAL] Failed to execute query SELECT DISTINCT a.id FROM SystemUsers a WHERE ( (a.username='{USER_NAME}')) for query 111111111111111
[wcmint_wcsites] [NOTIFICATION] [] [oracle.wcsites.cs] [tid: 133] [userId: <anonymous>] [APP: sites] [partition-name: DOMAIN] [tenant-name: GLOBAL]  [Directory-F--15030][CSDir:doUserSearch(ICS, Attributes, boolean)][Query SQL failed, errno=-105.]
[wcmint_wcsites] [ERROR] [] [oracle.wcsites.auth] [tid: 133] [userId: <anonymous>] [APP: sites] [partition-name: DOMAIN] [tenant-name: GLOBAL] Exception thrown while getting user from user name <{USER_NAME}>.[[
com.openmarket.directory.DirectoryException: -105
       at com.openmarket.directory.common.DirLogger.throwFatalException(DirLogger.java:53)
       at com.openmarket.directory.cs.CSDir.verifyIList(CSDir.java:1432)
       at com.openmarket.directory.cs.CSDir.doUserSearch(CSDir.java:434)
       at com.openmarket.directory.cs.CSDir.andSearch(CSDir.java:239)

Changes

Cause

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