Subject Re: [ib-support] ROLE in gbak
Author Claudio Valderrama C.
""Marcos Vinicius Dufloth"" <dufloth@...> wrote in message
news:004601c16f5c$e1955860$862bf8c8@dufloth...
> Yes, of course. I'm not stupid. And I ask again, for what? This will make
I
> backup only that things I have permission in role? No. Then, for what?

In theory, only sysdba and the db owner should be able to backup a db. If
another user wants to do the trick, probably the intention was that this
should be possible, provided that:
- there's a role R that was granted rights over all objects (or at least
SELECT rights in most cases)
- there's a user U that's neither sysdba nor the db owner but that was
granted role R
- user U connects with role R through gbak to do the backup

I never have tried if this works in practice.

C.
--
Claudio Valderrama C. - http://www.cvalde.com - http://www.firebirdSql.org
Independent developer
Owner of the Interbase® WebRing