Ok, thank you very much.

And how we can know the other privileges?

If Alice has no role but had received privileges with GRANT, how we can know
which privileges she has?

Thanks in advance.

Walter.

On Wed, May 18, 2011 at 3:34 AM, Thomas Steinmaurer <ts@...>wrote:

>
>
> > SELECT RDB$USER, RDB$RELATION_NAME
> > FROM RDB$USER_PRIVILEGES
> > WHERE RDB$PRIVILEGE = 'M' AND RDB$USER = 'ALICE'
> > ORDER BY 1, 2
> >
> > I can get Alice's roles, but I don't know what the 'M' means.
> >
> > Do you know?
>
> Short for member / membership.
>
>
> --
> With regards,
>
> Thomas Steinmaurer
> Upscene Productions
> http://www.upscene.com
> http://blog.upscene.com/thomas/
>
> Download LogManager Series, FB TraceManager today!
> Continuous Database Monitoring Solutions supporting
> Firebird, InterBase, Advantage Database, MS SQL Server
> and NexusDB!
>
>
>


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