Insufficient privilege

[florida1987]

I am using my Username (Jones) to login to Oracle 9i Database. Once logged in I can create tables, add records and edit records in a Schema called City. The issue is I cant delete a record in City schema. I get the message "Ora-01031 - insufficient privileges".

DBA says it might be a problem (or bug) with client OEM or SQL Plus. Please advise what can be done to allow me to delete a record in the City Schema.

 

[SantaMufasa]

Florida,

Remember: often, when people cannot figure out what is causing otherwise-unexplained software behaviour, their default explanation is, "It must be a bug."

In your case, I'm certain that we can figure out what is causing the unexplaned behaviour, and I'll bet that it is not a bug.

To help diagnose the cause, please run the following SQL*Plus commands (replacing values in the "<value>" entries with correct values appropriate for your situation), and post the results back here to this thread:

connect jones/<password>@<your tns alias>
spool JonesPrivileges.txt
select granted_role from user_role_privs
/
select privilege from user_sys_privs
/
select grantee, owner, table_name, privilege
from user_tab_privs
where owner = 'CITY'
  and table_name = '<place table name here in ALL CAPS>'
order by grantee, owner, table_name, privilege
/
spool off

Looking forward to your reply.

Mufasa
(aka Dave of Sandy, Utah, USA)
[I provide low-cost, remote Database Administration services: www.dasages.com]