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 : 23-04-2017
ORA-28556

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

  • ora-10634 : Segment is already being shrunk
  • ora-10645 : Recursive Extension in SYSTEM tablespace during migration
  • ora-24403 : error occured while trying to destroy the connection pool
  • ora-23505 : Object "string"."string" is missing.
  • ora-22276 : invalid locator for LOB buffering
  • ora-13230 : failed to create temporary table [string] during R-tree creation
  • ora-10854 : Sets poll count used for AQ listen code under RAC
  • ora-09351 : Windows 32-bit Two-Task driver unable to allocate shared memory
  • ora-19240 : XP0020 - context item must be node in an axis expression
  • ora-13844 : no new SQL profile name or category specified.
  • ora-30967 : operation directly on the Path Table is disallowed
  • ora-30180 : argument index is too large
  • ora-00607 : Internal error occurred while making a change to a data block
  • ora-14041 : partition bound may not be specified for resulting partitions
  • ora-02081 : database link is not open
  • ora-16092 : dependent archive log destination is not active
  • ora-30061 : Internal Event for Savepoint Tracing
  • ora-12668 : Dedicated server: outbound protocol does not support proxies
  • ora-16546 : missing or invalid piece
  • ora-13455 : GeoRaster metadata TRS error
  • ora-29378 : invalid consumer group mapping priorities
  • ora-30013 : undo tablespace 'string' is currently in use
  • ora-03209 : DBMS_ADMIN_PACKAGE invalid file/block specification
  • ora-24100 : error in ktz testing layer
  • ora-30369 : maximum number of columns is 32
  • ora-12456 : label security startup in progress
  • ora-15019 : discovered duplicate path 'string' for 'string'
  • ora-19246 : XQ0026 - validation failed - element string not found in in-scope element declarations
  • ora-03001 : unimplemented feature
  • ora-38730 : Invalid SCN/TIMESTAMP expression.
  • 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.