I had just learned how to create an SQL DBE a couple weeks ago myself.

Correct me if I'm wrong, but if the Image DB is in group "a" and the user desires the DBE to be in group "b," ... I'm not sure a DBE can be created in another group.

(The behavior seems similar to third party indexing.  I don't think I could put an Omnidex 0A, 0B, 0C, etc files in a different group than the original database.)

BT


Tracy Johnson
MSI Schaevitz Sensors 

> -----Original Message-----
> From: HP-3000 Systems Discussion [mailto:[log in to unmask]]On
> Behalf Of Scott Swartzell
> Sent: Tuesday, March 22, 2005 8:55 AM
> To: [log in to unmask]
> Subject: [HP3000-L] Grant/Revoke disallowed, creating DBE
> 
> 
> Good morning all,
> 
> A user called with this error, and I'm not too strong on this subject.
> 
> They're trying to get from an Image DB to MS Access.  As an 
> intermediate
> step, they're trying to create a DBE file from Image, then 
> get the "Special
> GRANT/REVOKE disallowed for reserved user MGR@xxxx (DBERR 2306)."
> 
> The mgr.xxxx is the creator of the Image DB.
> 
> The image db is in a.xxxx, all access=any.
> 
> He's trying to create the DBE in b.xxxx, all access=gu.
> 
> In a.xxxx, there's already a DBE associated with this DB.
> 
> Any suggestions?
> 
> Thanks,
> Scott
> --
> ---------------------------------------------
> Scott Swartzell   IT | Information Technology
>              590-2152
> 9/20 - Mt Antero (14,269')
> 8 down, 46 to go.........
> 
> * To join/leave the list, search archives, change list settings, *
> * etc., please visit http://raven.utc.edu/archives/hp3000-l.html *
> 

* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *