Insufficient Privileges?

From: Dan White <dgwhiteNOSPAM_at_telusplanet.net>
Date: Wed, 27 Feb 2002 11:02:54 -0700
Message-ID: <3C7D1F4E.5030106@telusplanet.net>

I Have Oracle 8.1.7 installed on Windows 2000 sp2. I am setting the server up for the official Oracle curriculum. We used to teach Oracle 8, now we are moving to 8i. I have scripts for a workshop that set tables specific to a course we teach. The problem I am having is with the final script that sets permissions to the tables.

The exact syntax I am using is as follows:

Grant Select, Insert, References On HQ_NATIONAL.Personal_Credit to IS_NS;

(all one line)

The result I get is "Error at line 1 Insufficient Privileges"

I log into SqlPlus as system/manager_at_v8i

I used this account to setup all the other tables etc.

I granted sysdb to sys and system but this didn't help.

Can anyone see what I am doing wrong, I am stumped!

Thanks,

Dan Received on Wed Feb 27 2002 - 12:02:54 CST