Re: [Firebird-devel] DEFAULT grants to PUBLIC
On 10-05-2022 12:10, Dimitry Sibiryakov wrote: Roman Simakov wrote 10.05.2022 10:21: It makes sense. Could you create a ticket? But what's the point to grant object rights to the role and then grant the role to public instead of granting the rights to public directly? Just like with normal default roles: granularity. You can group related permissions together, and make is easier to revoke those permissions en bloc if you no longer want everyone to have them. Mark -- Mark Rotteveel Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] DEFAULT grants to PUBLIC
Roman Simakov wrote 10.05.2022 10:21: It makes sense. Could you create a ticket? But what's the point to grant object rights to the role and then grant the role to public instead of granting the rights to public directly? -- WBR, SD. Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] DEFAULT grants to PUBLIC
On 10/05/2022 05:21, Roman Simakov wrote: > It makes sense. Could you create a ticket? > https://github.com/FirebirdSQL/firebird/issues/7178 Adriano Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] DEFAULT grants to PUBLIC
It makes sense. Could you create a ticket? вт, 10 мая 2022 г. в 04:31, Adriano dos Santos Fernandes : > > Hi! > > A role can be default granted to PUBLIC. > > create role r1; > grant default r1 to public; > > In this case I think the role should be act as a defaulted role to every > user. > > But it's not working. > > The role privileges only works if user uses it explicitly. > > > Adriano > > > Firebird-Devel mailing list, web interface at > https://lists.sourceforge.net/lists/listinfo/firebird-devel -- Роман Симаков Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel