Hiding PG/SQL functions
От | biggero@poczta.onet.pl |
---|---|
Тема | Hiding PG/SQL functions |
Дата | |
Msg-id | Q95911624-3d7e5f6837e1d37ab88f566f5dfa5010@pmq5.test.onet.pl обсуждение исходный текст |
Ответы |
Re: Hiding PG/SQL functions
|
Список | pgsql-admin |
Hi, I have PG/SQL functions in Postgres database created using sequence of following statements: (example) CREATE OR REPLACE FUNCTION get_data RETURNS integer AS $$ ... $$ LANGUAGE plpgsql; These PG/SQL functions can be viewed using pgAdmin. I don't like this because users can see the internal structure of myprogram and they will try to cheat my program. My questions are: 1. How can you hide PG/SQL functions from other users, so that they can't see the functions, but they can still execute them? 2. What do you think about this idea: Can you embed PG/SQL function in a C code, compile it to a shared library and thenlet the users use it? How do you do that? This would protect my functions (I think). I would rather not give up PG/SQL language as the procedures are almost ready. So embedding PG/SQL in C is feasible, whilewriting all procedures from the scratch rather not. 3. Where can I find more details about database security in this respect (ie. protection of my code). Even some links tothe manual would be helpful. Thanks for the answers. I am just not kind of admin guy, I am kind of programmer guy. Bigg
В списке pgsql-admin по дате отправления: