System Privilege to Select/Execute Database Procedures Only

[Luciano Rodrigues Nunes Mendes]

Hi guys

Is there any system privilege that can be assigned to a Role that allows it to only Select/Execute database procedures?

I was reading the Firebird 4.0.4 Release Notes - List of Valid System Privileges and it didn't seem clear which of the privileges I could use for this Role.

Thanks in Advance,

Luciano

[Dimitry Sibiryakov]

Luciano Rodrigues Nunes Mendes wrote 02.06.2024 4:20:
> Is there any system privilege that can be assigned to a Role that allows it to
> only Select/Execute database procedures?

No. You have to grant SELECT/EXECUTE privileges to every table and SP
individually.
Some tools like IBExpert can to it for you automagically.

--
WBR, SD.

[Luciano Rodrigues Nunes Mendes]

Thanks for your help Dmitry!

Best Regards,

Luciano

--
You received this message because you are subscribed to the Google Groups "firebird-support" group.
To unsubscribe from this group and stop receiving emails from it, send an email to firebird-suppo...@googlegroups.com.
To view this discussion on the web, visit https://groups.google.com/d/msgid/firebird-support/434c8e67-6662-4c7f-8900-f1a9193f5068%40ibphoenix.com.