How to keep the PostgreSQL "System Administration/Information functions" from read-only users
In my case, a read-only user can perform the "System Administration/Information functions".
I tried to restrict those functions by hard-coding that in my code. But that cannot be a proper solution, since there can be new such functions in future rele开发者_运维问答ases of PostgreSQL, or functions may get renamed.
So I need to get those functions dynamically. Is there a way to determine which function belong to the "System Administration/Information functions", or how to restrict access to them for a read-only user?
精彩评论