Hi Milan,


Milan Babuskov wrote:

>Alexandre Benson Smith wrote:
>
>
>>As I understand the former will grant to a user or role and take the
>>name of a procedure/trigger as the user/role name. What I wonder is why
>>FB let me grant something to a invalid user/role.
>>
>>
>
>It would let you because users are not defined in the same database.
>Users are server-wide and Firebird does not check the security database
>when you issue GRANT statements. I find this feature useful since it
>allows me to grant privileges on developement database (where the server
>only has few users) and backup/restore that database on production
>server where there are many, many users.
>
>

That is what I thougth to be the reason

>
>
>>If it complain about
>>it I will in a snap realize that I forget the procedure/trigger word.
>>
>>
>
>IIRC, you have this in Vulcan, and it will be available in Firebird 3.0.
>
>
>

Are you talking about the grant complain about users or the fact that in
Vulcan I will be enbale to have users in local databases ?

>>Any comments ?
>>
>>
>
>Perhaps you should use some tool to grant privileges instead of typing
>SQL manually.
>
>
>

We have a copy of IBExpert but it's not on my machine.

And it goes to the update database script, I go to my costumers run the
script for the version he has til the current version. So every comand
need to be in this script. I know some tools have recording features but
I use a lot IBConsole (yes, the old one !)

By the way, I like to type :-)

see you !

--
Alexandre Benson Smith
Development
THOR Software e Comercial Ltda
Santo Andre - Sao Paulo - Brazil
www.thorsoftware.com.br