Étienne BERSAC
Étienne BERSAC
It's not possible yet. It's a known regression from v5. However, it's likely to comme back like this: ``` yaml acl: FUNCTION: inspect: ... grant: ... revoke: ... privileges: ro:...
> I have another question ... It is possible to specify a config for roles, such as the log_statement. > > ``` > - roles: > - name: my-db-writer >...
Fixed in 6.3
Hi @kkrasnov1 . Thanks for the feedback. Ok to use routine. Can you open a pull request with this ?
> The ability to grant permissions to routines appeared in version 11 of PostgreSQL. PostgreSQL versions prior to 11 will be unsupported. Is this acceptable? Good point. This is not...
Hi @kkrasnov1 , thanks for reaching. Can you share a sample procedure object, with ACL and owner ? Use `\df+` for example.
> Hi @bersace, Is it possible to grant privileges to stored procedures? You can manage EXECUTE on *all* functions with `__execute_on_functions__` privilege. See https://ldap2pg.readthedocs.io/en/latest/builtins/#execute-on-functions
> Hi @bersace, Is it possible to grant privileges to stored procedures? You can manage only privileges per schema. No finer granularity.
> @bersace, every time I start, I get a message CHANGE Revoke privilege. grant="EXECUTE ON ALL FUNCTIONS IN SCHEMA userdb.ldap2pg_test TO myuser" database=userdb > > Am I doing something wrong...
Bonjour, veuillez laissez ouvert. ldap2pg ne doit pas paniquer en cas de mauvais paramètres.