ORA-28116: insufficient privileges to do direct path access

Cause : Users with insufficient privileges attempting to do direct path access of tables with fine grain access control policies.

Action - How to fix it : DBA Scripts :: www.high-oracle.com/scripts

Ask the database administrator to do the operation. Note that users can work with security administrator to temporarily drop/disable the policies at time of export, import, or load, but this has security implication, and thus access of the database must be controlled carefully.

update : 20-09-2017
ORA-28116

ORA-28116 - insufficient privileges to do direct path access
ORA-28116 - insufficient privileges to do direct path access

  • ora-12608 : TNS: Send timeout occurred
  • ora-25232 : duplicate recipients specified for message
  • ora-14001 : LOCAL clause contradicts previosly specified GLOBAL clause
  • ora-01690 : sort area size too small
  • ora-25236 : buffer too small for user data
  • ora-31653 : unable to determine job operation for privilege check
  • ora-00288 : to continue recovery type ALTER DATABASE RECOVER CONTINUE
  • ora-36612 : (XSLMS01) invalid OLAP message number: value
  • ora-29293 : A stream error occurred during compression or uncompression.
  • ora-07718 : sksafre: error freeing memory
  • ora-07274 : spdcr: access error, access to oracle denied.
  • ora-31698 : Error stack buffer size must be specified and must be greater than 0.
  • ora-01204 : file number is string rather than string - wrong file
  • ora-16630 : that database property was deprecated
  • ora-25158 : Cannot specify RELY for foreign key if the associated primary key is NORELY
  • ora-28278 : No domain policy registered for password based GLOBAL users.
  • ora-19816 : WARNING: Files may exist in string that are not known to database.
  • ora-22869 : depth of type dependency hierarchy exceeds maximum limit
  • ora-37074 : (XSMCSESS02) Variable workspace object has no default aggmap.
  • ora-24155 : rule string.string not in rule set string.string
  • ora-32405 : cannot alter tablespace for existing materialized view log
  • ora-15171 : invalid syntax in the alias path after 'string'
  • ora-32843 : value for string is outside the valid range of string to string
  • ora-30690 : timeout occurred while registering a TCP/IP connection for data traffic detection
  • ora-39025 : jobs of type string are not restartable
  • ora-25136 : this cluster can contain only one table
  • ora-06815 : TLI Driver: could not link SPX and IPX streams
  • ora-30357 : this PL/SQL function cannot be supported for query rewrite
  • ora-03281 : invalid ALLOCATE EXTENT option
  • ora-28578 : protocol error during callback from an external procedure
  • Oracle Database Error Messages



    Oracle Database High Availability Any organization evaluating a database solution for enterprise data must also evaluate the High Availability (HA) capabilities of the database. Data is one of the most critical business assets of an organization. If this data is not available and/or not protected, companies may stand to lose millions of dollars in business downtime as well as negative publicity. Building a highly available data infrastructure is critical to the success of all organizations in today's fast moving economy.

    Well, the reason for above error is that i have taken the above script from a 11g database and running it on 10g database. 11g has bring some changes in password management. Below code is executed on 11g and user created successfully, which is expected result.