> 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!