ora-1031

I have 3 triggers that are giving an ora-1031, below is an example: ON AUTH_ADDTL_INFO * ERROR at line 16: ORA-01031: insufficient privileges The same schema owns the tables and the triggers. Let me repeat, the tables exist and are owned by the same schema as the triggers. I can

RE: ora-1031

, 2003 2:10 PM To: Multiple recipients of list ORACLE-L I have 3 triggers that are giving an ora-1031, below is an example: ON AUTH_ADDTL_INFO * ERROR at line 16: ORA-01031: insufficient privileges The same schema owns the tables and the triggers. Let me repeat, the tables exist

RE: ora-1031

for l_active_trigger, does it make any difference? Roy Pardee Programmer/Analyst/DBA SWFPAC Lockheed Martin IT Extension 8487 -Original Message- Sent: Tuesday, June 17, 2003 2:10 PM To: Multiple recipients of list ORACLE-L I have 3 triggers that are giving an ora-1031, below is an example

Ora-1031 (Insufficient Privileges) Inserting BLOB Data With Perl

One of our developers has written a program to upload files into the database via perl. The actual file contents are stored in a blob. The table was created with the following script CREATE TABLE BP_FILES (FILE_ID NUMBER(7,0) NOT NULL ,FILE_TYPE VARCHAR2(1) NOT NULL ,FILE_FORMAT

Re: Ora-1031 (Insufficient Privileges) Inserting BLOB Data With Perl

Do 'other users' have any quota on 'BABAR_PAPERS_DATA' tablespace (where LOB is stored)? Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, November 20, 2001 8:15 AM One of our developers has written

RE: Ora-1031 (Insufficient Privileges) Inserting BLOB Data With P erl

Resource on the tablespace should not matter. I don't want them to be able to create segments, but to perform DML on the lob_segment already there. If I use sqlplus and the dbms_lob functions in an anonymous pl/sql block then the insert is successful when the privileges on the table are

RE: Ora-1031 (Insufficient Privileges) Inserting BLOB Data With P erl

A correction to my last the sql*plus program works with roles as well as direct grants. Ian -Original Message- Sent: Tuesday, November 20, 2001 6:30 AM To: Multiple recipients of list ORACLE-L Perl Do 'other users' have any quota on 'BABAR_PAPERS_DATA' tablespace (where LOB is

RE: Ora-1031 (Insufficient Privileges) Inserting BLOB Data With P erl

Solved??. It seems update privileges are needed on the table even though the perl script is doing an insert. Ian MacGregor Stanford Linear Accelerator Center [EMAIL PROTECTED] -Original Message- Sent: Tuesday, November 20, 2001 5:15 AM To: Multiple recipients of list ORACLE-L Perl

Re: Ora-1031 (Insufficient Privileges) Inserting BLOB Data With P erl

Could it be, that it first creates a record with NULL in blob column using EMPTY_BLOB(), and then updates blob column? Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, November 20, 2001 3:35 PM erl

Re: ora-1031 when connect internal or / as sysdba locally

Check your $ORACLE_HOME/rdbms/audit directory. If it is full, you will get this error, as every time you try to login to svrmgrl connect connect internal, a .aud file is created here. Terry Chuan Zhang wrote: Dear all,I have this problem. When connect internal or connect /as sysdba in

ora-1031 when connect internal or / as sysdba locally

Dear all, I have this problem. When connect internal or connect /as sysdba in svrmgrl, it gives me insufficient priviledge. I connect it locally instead of remotly. I have not set up any password file or os authentication. It works well last week and suddenly happens today when I want to