"Roman Rokytskyy" <rrokytskyy@...> wrote:

>
> INSERT INTO SYS$BACKUPS(SYS$DESTINATION)
> VALUES('/var/db/backups/my.fbk');

No, please ;-)

> What in fact we need, is a priviledge to perform that operation. And
> we already have this priviledge - GRANT EXECUTE PROCEDURE ON ...
>
> So what is left, is to export all those database level operations as
> procedures and then simply grant EXECUTE PROCEDURE on the
> corresponding object to corresponding roles with GRANT OPTION.

Well, then we'll start looking like MSSQL with their tons of admin-targeted
stored procedures. I see some value here, but before this day I hated this
approach in MSSQL.


Dmitry