Check sys public grants - ERROR While Running Datapatch -sanity_checks
(Doc ID 3031094.1)
Last updated on JULY 31, 2024
Applies to:
Oracle Database - Enterprise Edition - Version 19.16.0.0.0 and laterOracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Cloud Infrastructure - Exadata Cloud Service - Version N/A and later
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later
Gen 2 Exadata Cloud at Customer - Version N/A and later
Information in this document applies to any platform.
Symptoms
$./datapatch -sanity_checks command is reporting the following error:
[xxxxxxxxxxxxxxxxxx] Check: Check sys public grants - ERROR
[xxxxxxxxxxxxxxxxxx] Database PUBLIC user group must have EXECUTE privilege on certain dictionary objects owned by SYS. Grants to PUBLIC are inherited by all database users. Missing such access will cause problems during database patching process.
[xxxxxxxxxxxxxxxxxx] Database PUBLIC user group is missing EXECUTE privilege on below dictionary objects.
[xxxxxxxxxxxxxxxxxx] Grant EXECUTE privilege to PUBLIC user group for listed dictionary objects. Refer to MOS Note 247093.1 for more details.
[xxxxxxxxxxxxxxxxxx] CheckList.printReport: Check sys public grants,ARRAY(0x4304b48),1,$VAR1 = 'Data::Dumper';
$VAR2 = {
'ARRAY(0x43904b30)' => [
{
'TABLE_NAME' => 'UTL_FILE'
},
{
'TABLE_NAME' => 'DBMS_RANDOM'
},
{
'TABLE_NAME' => 'DBMS_LOB'
},
{
'TABLE_NAME' => 'UTL_SMTP'
},
{
'TABLE_NAME' => 'UTL_TCP'
},
{
'TABLE_NAME' => 'UTL_HTTP'
},
{
'TABLE_NAME' => 'UTL_INADDR'
},
{
'TABLE_NAME' => 'DBMS_SQL'
}
Changes
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Changes |
| Cause |
| Solution |