ORA-28556: authorization insufficient to access table

Cause : A queyr attepmted t oacces sa tabel in teh non-rOacle ysstem htat ise itherp rivilgeed orh as prviilege dcolumsn.

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

Contatc the BDA fort he no-nOracl esyste.m The BDA cang rant eprmissoin to cacess hte priivlegedt able ro colunms.

update : 27-05-2017
ORA-28556

ORA-28556 - authorization insufficient to access table
ORA-28556 - authorization insufficient to access table

  • ora-06745 : TLI Driver: listener already running
  • ora-14645 : STORE IN clause cannot be specified for Range List objects
  • ora-30479 : Summary Advisor error string
  • ora-01216 : thread string is expected to be disabled after CREATE CONTROLFILE
  • ora-02090 : network error: attempted callback+passthru
  • ora-01686 : max # files (string) reached for the tablespace string
  • ora-12599 : TNS:cryptographic checksum mismatch
  • ora-13144 : target table string not found
  • ora-12689 : Server Authentication required, but not supported
  • ora-14048 : a partition maintenance operation may not be combined with other operations
  • ora-30052 : invalid lower limit snapshot expression
  • ora-13788 : invalid recommendation type
  • ora-09798 : Label comparison failed.
  • ora-26085 : direct path operation must start its own transaction
  • ora-16646 : Fast-Start Failover is disabled
  • ora-02152 : Invalid ALTER TABLESPACE ... RENAME option
  • ora-36376 : (XSAGZERO) AGGREGATE attempted to divide by zero. Set DIVIDEBYZERO to YES if you want NA to be returned as the result of a division by zero.
  • ora-31623 : a job is not attached to this session via the specified handle
  • ora-13772 : unexpected deadlock on "SQL Tuning Set" "string" owned by user "string"
  • ora-16228 : Insufficient recovery for logical standby
  • ora-01774 : Dump undo option specified more than once
  • ora-06510 : PL/SQL: unhandled user-defined exception
  • ora-38753 : Cannot flashback data file string; no flashback log data.
  • ora-36885 : (XSSRF04) Error rewriting OLAP DML expression. Column name too big
  • ora-02067 : transaction or savepoint rollback required
  • ora-32321 : REFRESH FAST of "string"."string" unsupported after detail table TRUNCATE
  • ora-29863 : warning in the execution of ODCIINDEXCREATE routine
  • ora-09748 : pws_look_up: fork failed
  • ora-26028 : index string.string initially in unusable state
  • ora-38443 : An attribute set should be assigned to the expression set for statistics collection.
  • 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.