Re: Insufficient privileges
From: Carlos <miotromailcarlos_at_netscape.net>
Date: Fri, 1 Feb 2008 00:58:04 -0800 (PST)
Message-ID: <29ae355a-9f2e-4097-9aef-b8d6f74f4d95@k39g2000hsf.googlegroups.com>
Date: Fri, 1 Feb 2008 00:58:04 -0800 (PST)
Message-ID: <29ae355a-9f2e-4097-9aef-b8d6f74f4d95@k39g2000hsf.googlegroups.com>
On 1 feb, 02:11, "tes..._at_hotmail.com" <tes..._at_hotmail.com> wrote:
> 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 with client OEM or SQL Plus. Please
> advise what can be done to allow me to delete a record in the City
> Schema.
GRANT DELETE ON CITY.THE_TABLE TO JONES? Cheers.
Carlos Received on Fri Feb 01 2008 - 02:58:04 CST