Subject | Re: [firebird-support] Does GRANT... TO PUBLIC has no more effect anymore? |
---|---|
Author | Mark Rotteveel |
Post date | 2018-11-11T10:29:43Z |
On 10-11-2018 13:33, Mark Rotteveel mark@...
[firebird-support] wrote:
can define a mapping that will automatically grant and enable a role.
Mark
--
Mark Rotteveel
[firebird-support] wrote:
>> I can confirm it works correctly in 2.5.x (can't say anything about 3.xAnd I just found out that with Firebird 3's authentication mapping, you
>> though). We're using the same approach (the users of our system are
>> actually created as FB users, so granting access to PUBLIC is more
>> convenient than having to execute dozens of grants after adding each new
>> user; I know it has some downsides, but that's not the point here).
>
> Firebird 4 will introduce default roles (though technically PUBLIC is a
> default role as well) which will allow more control by granting users a
> default role. That way they will get the rights of those default roles
> without having to explicitly specify a role on connect.
can define a mapping that will automatically grant and enable a role.
Mark
--
Mark Rotteveel