| Subject | Re: [firebird-support] How can I know which are the roles that a user have? |
|---|---|
| Author | Thomas Steinmaurer |
| Post date | 2011-05-18T07:34:16Z |
> SELECT RDB$USER, RDB$RELATION_NAMEShort for member / membership.
> 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?
--
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!