Личный кабинет
Укажите e-mail, на который будет выслан код восстановления пароля.
На указанный вами адрес e-mail был выслан код подтверждения аккаунта. Введите полученный код для продолжения:
Введите новый пароль два раза:
HiI want to hide my own stored procedures' bodies from the specific user.As far as I know, procedure's body is visible in the pg_catalog.pg_proc table.So, I did the following:REVOKE ALL ON pg_catalog.pg_proc FROM PUBLIC;And after it, when user tries:SELECT * from pg_proc;The following error occurs:ERROR: permission denied for relation pg_procIt turns out that user don't have access to the body of the procedure.But I still can get stored procedure's body using\sf function_name or with \ef function_nameSo, how can I completely hide my own stored procedure's bodies from this user?Thanks in advanceSaimon
В списке pgsql-general по дате отправления: