01106 SEC UAR User already has resource authority :remedy none

[jipsi]

Hi

I have this message whenI done :
set server spibases;
Create Database pfmb1000;
Connect pfmb1000 sysadm/sysadm;
Load Sql d:\echange\pfmb.sql;

on the "load" instruction
SQLbase 8.5.0 PFT3

Any Idea ??
thank's

jipsi

 

[OliverA]

I think the load process tries to do a 'GRANT RECOURCE... ' to an user which already has this authority.
If the unload file is not an compressed unload please open it with an editor in text mode an try to find out the line where this happens.