Perfect!!!

Excellent!!!

Thank you very much.

Walter.

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

>
>
> > 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?
>
> Hmm, by querying the RDB$USER_PRIVILEGES system table. ;-)
>
> Where RDB$PRIVILEGE is storing the privilege type:
>
> S = SELECT
> D = DELETE
> I = INSERT
> U = UPDATE
> R = REFERENCES
> M = MEMBER OF role
> X = EXECUTE
>
> RDB$RELATION_NAME holds the name of the granted object (table, view,
> stored procedure ...)
>
>
> --
> 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]