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