Error
Error Code: ORA-28122

Oracle Error ORA-28122: SYS_DEFAULT Policy Error

📦 Oracle Database
📋

Description

The ORA-28122 error occurs in Oracle Database when you try to create or delete the `SYS_DEFAULT` policy group using `DBMS_RLS.CREATE_POLICY_GROUP` or `DBMS_RLS.DELETE_POLICY_GROUP`. The `SYS_DEFAULT` policy group is a system-defined group and cannot be directly manipulated.
💬

Error Message

ORA-28122: can not update SYS_DEFAULT policy group
🔍

Known Causes

2 known causes
⚠️
Attempting to Create SYS_DEFAULT
The user tried to create a policy group named `SYS_DEFAULT`, which is a reserved name.
⚠️
Attempting to Delete SYS_DEFAULT
The user attempted to delete the system-defined `SYS_DEFAULT` policy group, which is not permitted.
🛠️

Solutions

Coming Soon

Detailed step-by-step solutions for this error are being prepared. In the meantime, try these general troubleshooting tips:

General Troubleshooting Tips

  • Check the error message carefully for specific details
  • Review recent changes that might have caused the error
  • Search for the exact error code in the official documentation
  • Check log files for additional context
  • Try restarting the application or service

Find Help

Stack Overflow Google Search Official Docs