Works fine!

Thank you!

Juan Jose

--- In firebird-support@yahoogroups.com, "Thomas Steinmaurer"
<ts@...> wrote:

>
> > ok!
> > This works for all the roles:
> > select rdb$role_name
> > from rdb$roles
> >
> > but, I still can't get the relation between roles and users.
>
> select
> rdb$relation_name as role_name
> from
> rdb$user_privileges
> where
> rdb$privilege = 'M'
> and rdb$user = <your_user>
>
>
> Best Regards,
> Thomas Steinmaurer
> LogManager Series - Logging/Auditing Suites supporting
> InterBase, Firebird, Advantage Database, MS SQL Server and
> NexusDB V2
> Upscene Productions
> http://www.upscene.com
>