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 : 28-07-2017
ORA-28556

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

  • ora-07657 : slsprom:$ASSIGN failure
  • ora-27488 : unable to set string because string was/were already set
  • ora-01868 : the leading precision of the interval is too small
  • ora-12626 : TNS:bad event type
  • ora-25472 : maximum open iterators exceeded
  • ora-39763 : stream must be completely loaded before it is reset
  • ora-06018 : NETASY: message send failure
  • ora-01300 : writable database required for specified LogMiner options
  • ora-02715 : osnpgetbrkmsg: message from host had incorrect message type
  • ora-14636 : only 2 resulting subpartition can be specified for SPLIT SUBPARTITION
  • ora-09812 : Unable to get user clearance from connection
  • ora-36154 : (XSMXAGGR01) workspace object is not a data variable.
  • ora-13111 : cannot add topo_geometry layer [string] to topology
  • ora-36163 : (XSMXAGGR06) The AGGREGATE function cannot be run on more than one variable at a time.
  • ora-13510 : invalid RETENTION string, must be in the range (string, string)
  • ora-02377 : invalid resource limit
  • ora-38755 : Flashback is already turned on for this tablespace.
  • ora-09215 : sfqio: error detected in IOCompletionRoutine
  • ora-13358 : circle type does not contain 3 points
  • ora-04934 : unable to obtain the current sequence number
  • ora-28603 : statement not permitted on empty tables
  • ora-38464 : expression set is not empty.
  • ora-13054 : recursive SQL parse error
  • ora-15195 : Internal ASM testing event number 15195
  • ora-06755 : TLI Driver: cannot close transport endpoint
  • ora-32578 : password for SYS already specified
  • ora-03127 : no new operations allowed until the active operation ends
  • ora-22283 : filename contains characters that refer to parent directory
  • ora-25329 : AQ array operations not allowed on 8.0 queues
  • ora-02203 : INITIAL storage options not allowed
  • 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.