Subject Re: [ib-support] ROLE in gbak
Author Marcos Vinicius Dufloth

Marcos Vinicius Dufloth
Tecnocyber, Ltda
Erechim - RS - Brasil
ICQ# 128291190

----- Original Message -----
From: "Claudio Valderrama C." <cvalde@...>
Newsgroups: egroups.ib-support
To: <>
Sent: Sunday, November 18, 2001 3:33 AM
Subject: Re: [ib-support] ROLE in gbak

> ""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
> 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. - -
> Independent developer
> Owner of the Interbase® WebRing
> To unsubscribe from this group, send an email to:
> Your use of Yahoo! Groups is subject to