HP3000-L Archives

March 2005, Week 4

HP3000-L@RAVEN.UTC.EDU
Options: Use Monospaced Font
Show Text Part by Default
Show All Mail Headers

Message: [<< First] [< Prev] [Next >] [Last >>]
Topic: [<< First] [< Prev] [Next >] [Last >>]
Author: [<< First] [< Prev] [Next >] [Last >>]

Print Reply
Subject:
Re: Grant/Revoke disallowed, creating DBE
From:
Scott Swartzell <[log in to unmask]>
Reply To:
Scott Swartzell <[log in to unmask]>
Date:
Tue, 22 Mar 2005 07:46:19 -0700
Content-Type:
text/plain
Parts/Attachments:
text/plain (78 lines) 
Tracy,

That's exactly what I thought, but I wasn't too sure.

If nothing else, it will be pretty easy to test.

Thanks for the quick response.

Scott

> 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 *
>


--
---------------------------------------------
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 *

ATOM RSS1 RSS2