Hi Helen, thanks for replying,

> Wish....wish...wish...we are talking about the SQL standard. "Smart" does
> not figure on its 10 Most Wanted. ;-)

=))

>But there are other reasons that you could say are Firebird-specific.
>"User" at logon is for server-
>level authentication. As it happens, users also exist in the SQL
>permissions (if you put them
>there). It is a matter of convenience to you that Firebird treats "server"
>users and "privileges"
>users as though they were the same thing. But they are not; and in fact
>you can grant permissions
>to users that don't exist at server level at all.

Once the use is authenticated by the server (and thus confirmed it exists)
it may not be hard at all to read it's granted rights and granted roles
(rights) that whould apply. Acctualy I think this alreary happens to rights
assigned direct to the user and assigned to 'public', so there *may* be no
big diference.

SQL standard?? I would'n mind this especific implementation was not, or at
least had a choice (conf) to. Imagine if on login of your Linux or Windows
you whould be asked to tell what's your 'user group' ??

Well, but I understand FB dev team has a lot of more important features to
work on, I just wish ;-) some day this gets "fixed"


Regards,
Anderson