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 my program 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 then let 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, while writing 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 to the manual would be helpful. Thanks for the answers. I am just not kind of admin guy, I am kind of programmer guy. Bigg -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
