Home » SQL & PL/SQL » SQL & PL/SQL » Privilege issue while trying to delete record
Privilege issue while trying to delete record [message #297457] Thu, 31 January 2008 16:39 Go to next message
florida
Messages: 82
Registered: April 2006
Member
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 the tables located in the 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.
Re: Privilege issue while trying to delete record [message #297458 is a reply to message #297457] Thu, 31 January 2008 16:59 Go to previous messageGo to next message
BlackSwan
Messages: 25038
Registered: January 2009
Location: SoCal
Senior Member
>DBA says it might be a problem (or bug) with client OEM or SQL Plus.
The DBA needs some remedial training.

>Please advise what can be done to allow me to delete a record in the City Schema.

Schemas do not contain records; but they can contain tables which contain records.

SQL> GRANT DELETE ON CTIY.TABLE1 TO JONES;
Re: Privilege issue while trying to delete record [message #297463 is a reply to message #297458] Thu, 31 January 2008 17:40 Go to previous message
florida
Messages: 82
Registered: April 2006
Member

anacedent,

Thanks for your quick reply! I will take this to the DBA first thing tomorrow morning.

Previous Topic: Query not working
Next Topic: Weird behaviour of Rownum
Goto Forum:
  


Current Time: Mon Dec 05 13:13:42 CST 2016

Total time taken to generate the page: 0.06692 seconds