Subject Re: [IBO] No permission to read/select COLUMN ENTERED
Author ra8009
--- In, Lester Caine <lester@...> wrote:
> Interleaved/bottom posting is preferred.
> ra8009 wrote:
> > I'm connecting to Firebird 1.5.2. There is no column called "COLUMN
> > ENTERED". The actual message is "No permission for read/select access
> > to COLUMN ENTERED" The error number is 335544352.
> And no 'COLUMN' called 'ENTERED' either?
> > The SQL Error message is: "The user does not have privledge to perform
> > this operation on this object".
> > The SQL statement that I'm using is: SELECT * FROM REGISTRATION_INFO.
> > When I write this statement into IB Admin, the table appears with no
> > problem.
> So are you using the same user name to log into your application and
> IBAdmin?
> What happens if you put the full list of field names in ( always
> preferred anyway ) then if there is no ENTERED field you can at least
> drop fields until the fault goes away ( if still present ;) )
> >>>I'm trying to open a cursor on a newly created table, but get the
> >>>message: "No permission to read/select COLUMN ENTERED" when I call
> >>>"Open" on my TIB_Cursor. What could be causing this?
> >>
> >>Tell us more. Does the set have a column named "COLUMN ENTERED"? Is
> >>it being requested via a join/subqyuery/view? Which db engine?
> --
> Lester Caine
> -----------------------------
> L.S.Caine Electronic Services
> Treasurer - Firebird Foundation Inc.

I am logging in as a different user. How do I check to see what
restrictions have been setup (someone else built part of the database.)

Do I need to grant rights to the table?