Tanks.

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

----- Original Message -----
From: "Claudio Valderrama C." <cvalde@...>
Newsgroups: egroups.ib-support
To: <ib-support@yahoogroups.com>
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
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
>
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>