YOU ROCK! I am suck an Idiot. Some time the small things get you!
Thanks a million.
Dan
santosh sharma wrote:
> 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:50:39 CST