CNC, DB and Operating System - JDE1 (MOSC)

MOSC Banner

SQL developer -what is priv to do TRUNCATE table?

edited Mar 31, 2017 12:27PM in CNC, DB and Operating System - JDE1 (MOSC) 1 commentAnswered

Hi,

what is priv to do TRUNCATE  table? I work with  SQL developer tool

pritn attached

I try to submit truncate from other schema/user:

Error starting at line 1 in command:

truncate table CRPDDTA.F5842435

Error report:

SQL Error: ORA-01031: insufficient privileges

01031. 00000 -  "insufficient privileges"

*Cause:    An attempt was made to change the current username or password

           without the appropriate privilege. This error also occurs if

           attempting to install a database without the necessary operating

           system privileges.

           When Trusted Oracle is configure in DBMS MAC, this error may occur

           if the user was granted the necessary privilege at a higher label

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center