Subject Re: [IBO] using stored procs, but no read/select access on table
Author Rob Schuff
hi jason,

can you please clarify what you mean by "the properties"? Do you mean the
IUD SQL properties? those are indeed correct

thanks!

rob
----- Original Message -----
From: "Jason Wharton" <jwharton@...>
To: <IBObjects@yahoogroups.com>
Sent: Friday, April 26, 2002 5:32 PM
Subject: Re: [IBO] using stored procs, but no read/select access on table


> You need to make sure you have setup the properties correctly.
> It may also be helpful for you to look at the SQL trace to see exactly
what
> it is doing.
> You may also have a LockSQL statement needed.
>
> HTH,
> Jason Wharton
> CPS - Mesa AZ
> http://www.ibobjects.com
>
>
> ----- Original Message -----
> From: "David Cornelius" <corneliu@...>
> To: <IBObjects@yahoogroups.com>
> Sent: Friday, April 26, 2002 4:05 PM
> Subject: [IBO] using stored procs, but no read/select access on table
>
>
> > I'm trying something new: using only stored procedure access from the
> connected user. So the IBOQuery components have statements like
> > SelectSQL: SELECT * FROM PRO_TABLE_S
> > UpdateSQL: EXECUTE PROCEDURE PRO_TABLE_U(params)
> > etc.
> >
> > Everything worked fine from the Delphi application with the connected
user
> being SYSDBA. But as soon as I switched to my new limited user, I started
> getting problems.
> >
> > The new, limited user was granted only execute rights to all stored
> procedures, and the stored procedures were granted access to their
necessary
> tables. Testing at the DB level (using IB Expert) seemed to indicate
> everything was set up fine--no direct access to the tables, but stored
> procedures worked fine once they had correct privileges.
> >
> > But the IBOQuery components seem to need direct table access.
Displaying
> the data seems to be fine, but as soon as I try to post any changes, I get
> the following error:
> >
> > ISC ERROR MESSAGE:
> > no permission for read/select access to table MyTable
> >
> > STATEMENT:
> > TIB_Statement:
>
"<TApplication>.MyDataModule.MyIBOQuery.IBOqrMyIBOQuery.<TIB_UpdateSQL>.<TIB
> _Statement>.
> >
> > STATEMENT:
> > TIBOInternalDataset:
> "<TApplication>.MyDataModule.MyIBOQuery.IBOqrMyIBOQuery.
> >
> >
> > Is there an IBO property I need to change or do I really need to grant
> more access to the user?
> >
> >
> > Thanks,
> >
> > David Cornelius
> >
>
>
>
>
___________________________________________________________________________
> IB Objects - direct, complete, custom connectivity to Firebird or
InterBase
> without the need for BDE, ODBC or any other layer.
>
___________________________________________________________________________
> http://www.ibobjects.com - your IBO community resource for Tech Info
papers,
> keyword-searchable FAQ, community code contributions and more !
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>