Comments below.

At 17/03/2001 00:48, you wrote:

>At 06:22 PM 16-03-01 -0400, you wrote:
> >Hi,
> >
> >I'm using IB 6.01. When connecting through the network from the client to
> >the server I get an error that I don't have READ/SELECT rights to a certain
> >view and the access rights are given for the user and role being
> >used. This error is given no matter what client computer I use.
>
>If your clients are logged in as a different user to the one who owns the
>database (i.e. the user who created it) then you must grant specific
>privileges to the non-owner users, to each object (table, view,
>procedure). You also need to grant privileges to procedures to access tables.
>
>You'll need the documentation for this. Come back and ask if you need a
>link for it.
>
>Cheers,
>Helen

Thanks for your reply Helen. I do have the documentation for
Interbase. What happens is that the user does have all the privileges, but
my colleague found out that if he revoked them and then granted them again
everything works fine. I'll look into this a bit deeper, because this
happens after he runs a program that I've written to update the database
structure, maybe I'm doing the grants in the wrong order.

Thanks again and have a nice day.


Daniel Rail
Senior System Engineer
ACCRA Group Inc. (www.accra.ca)
ACCRA Med Software Inc. (www.filopto.com)
SFI MARKETING GROUP (http://www.sixfigureincome.com/?531224)