--- In ib-support@yahoogroups.com, "Martijn Tonies" <m.tonies@u...> wrote:

>
> > > > SELECT RDB$ROLE_NAME
> > > > FROM RDB$ROLES
> > > >
> > > > How can I know if a User is assigned to a Role?. Is there a function
> like
> > > GetRolesOfUser(User: String): TStrings?
> > >
> > > Check the Language Reference, chapter System Tables and Views.
> > >
> > > Table RDB$USER_PRIVILEGES is what you're looking for.
> >
> > Yes, the answer was in Table RDB$USER_PRIVILEGES.
> >
> > If one user is assigned to a role then that user will appear in field
> RDB$USER and the role name in RDB$RELATION_NAME. Is this true?
> >
>
> Experiment a little yourself - the RDB$PRIVILEGE columns holds 'M' -> member
> of.
>
>
> With regards,
>
> Martijn Tonies
> InterBase Workbench - the developer tool for InterBase & Firebird
> Firebird Workbench - the developer tool for Firebird
> Upscene Productions
> http://www.upscene.com
>
> "This is an object-oriented system.
> If we change anything, the users object."

Ok, Thanks again and happy new year.