Subject | Re: [ib-support] ROLE in gbak |
---|---|
Author | Claudio Valderrama C. |
Post date | 2001-11-18T06:33:46Z |
""Marcos Vinicius Dufloth"" <dufloth@...> wrote in message
news:004601c16f5c$e1955860$862bf8c8@dufloth...
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
news:004601c16f5c$e1955860$862bf8c8@dufloth...
> Yes, of course. I'm not stupid. And I ask again, for what? This will makeI
> 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