connect as HQ_NATIONAL and then grant
hth
santysharma
"Dan White" <dgwhiteNOSPAM_at_telusplanet.net> wrote in message
news:3C7D1F4E.5030106_at_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:44:31 CST
