Subject Re: [Firebird-Architect] External engines - metadata
Author Roman Rokytskyy
>> Are you thinking something like GRANT CREATE TABLE TO PLUGIN JavaESP?
>
> No, of course no. But when plugin will create its objects ? When its registered
> by SYSDBA ? Then we need some kind of predefined event for plugin.

Yes, I was thinking in this direction. Last year or two years ago we
seems to have agreed that plugin has to be declared in the database,
something like DECLARE EXTERNAL ENGINE <name> LANGUAGE <name>
MODULE_NAME <path to dll> (just an example, we can think about other
syntax).

So yes, we would need some event to plugin.

> Or on first
> reference ? Then we have no guarantee that current user have necessary privileges
> to create tables (plugin have no own login and can access database using current
> user credentials). Also current user became owner of objects created by plugin -
> i don't like it.

I don't like it either - the SYSDBA or database owner seems to be right
approach.

Roman