Thank you for your replies

Dave, I already decided to go your way, I would have used views but
because of parameters I'll use stored procedures to pass the access right of
the user as parameter and in the stored procedure I'll do the necessary work
to fetch the necessary data, all forbidden fields will be returned as null

Vahan

-----Original Message-----
From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com]On Behalf Of davidalbiston
Sent: Friday, June 03, 2005 2:49 PM
To: firebird-support@yahoogroups.com
Subject: [firebird-support] Re: Roles in Firebird


Vahan

You could return the rows from a stored procedure. The SP can return a
null or data for forbidden columns depending on the user role.

Dave

--- In firebird-support@yahoogroups.com, Vahan Yoghoudjian
<vahan@p...> wrote:

> Hi Alexandre...
>
> It's pretty much what I want, let me give tell what I need for

and maybe

> you can give me hints...
>
>

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Visit http://firebird.sourceforge.net and click the Resources item
on the main (top) menu. Try Knowledgebase and FAQ links !

Also search the knowledgebases at http://www.ibphoenix.com

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++




----------------------------------------------------------------------------
----
Yahoo! Groups Links

a.. To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

b.. To unsubscribe from this group, send an email to:
firebird-support-unsubscribe@yahoogroups.com

c.. Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.




[Non-text portions of this message have been removed]