| Subject | Re: [firebird-support] How can I know which are the roles that a user have? |
|---|---|
| Author | Martijn Tonies |
| Post date | 2011-05-18T07:33:59Z |
> Writing something like:M-ember.
>
> 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?
With regards,
Martijn Tonies
Upscene Productions
http://www.upscene.com
Download Database Workbench for Oracle, MS SQL Server, Sybase SQL
Anywhere, MySQL, InterBase, NexusDB and Firebird!