This is an easy one.

Create a stored procedure in your database, where you issue a SELECT
RDB$PRIVILEGE FROM RDB$USER_PRIVILEGES WHERE (RDB$USER=:USER) AND
RDB$RELATION_NAME=:TABLE and grant the proper rights to the stored
procedure.
Now your datamodule can parse all queries for the affected tables before
opening and issue the SP and based on the result it can easily
enable/disable the Prevent_xxx properties.

CU, Nick

> -----Original Message-----
> From: guido.klapperich@...

[mailto:guido.klapperich@...]

> Sent: Friday, August 03, 2001 12:17 AM
> To: IBObjects@yahoogroups.com
> Subject: Re: [IBO] IB User-security with IBO
>
> > Instead of using LDAP you can store own tables in your database,

where

> > you
> > store the grants in a feasible way for every table and every role

and

> > read
> > them on the fly before opening your datasets. If you create a
> > base-datamodule with a nice loop in the on-create-handler, and

inherit

> > all
> > your other datamodules from this one, you should be pretty fine.
>
> Very interesting. Could you go a little bit more in the details,

perhaps

> with
> some code-examples ?
>
>
> Guido
>
>
> ------------------------ Yahoo! Groups Sponsor
>
>
>
> Your use of Yahoo! Groups is subject to

http://docs.yahoo.com/info/terms/

>