| Subject | Re: [firebird-support] How can I know which are the roles that a user have? |
|---|---|
| Author | W O |
| Post date | 2011-05-18T07:29:52Z |
Writing something like:
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?
Greetings.
Walter.
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?
Greetings.
Walter.
On Wed, May 18, 2011 at 2:03 AM, Thomas Steinmaurer <ts@...>wrote:
>
>
> > How can I know which are the roles that a user have?
>
> RDB$USER_PRIVILEGES system table.
>
> --
> 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]