Return
-
Title
IT Security Searcher fails during Enterprise Reporter index due to insufficient permissions -
Description
IT Security Searcher fails during index with the following message: "The EXECUTE permission was denied on the object 'udfBitmaskLookup', database 'dbReporter', schema 'dbo'." -
Cause
The specified user in the Enterprise Reporter connector requires at minimum, the following permissions:
-Read permission on the database-Execute permission on the database -
Resolution
WORKAROUND
Ensure the specified user has at least the following SQL permissions on the Enterprise Reporter database:
-Read permission on the database (dbReader role for example)
-Execute permission on the database
To grant execute permissions to the user see the following sample SQL (where User1 is the specified user account):USE dbReporterGRANT EXECUTE TO User1;STATUSWaiting fix in a future release of IT Security Search. -
Defect ID
IS-592 -
Additional Information
The additional permission was added to the documentation in the 11.3 version of IT Security Search