Pro*C and Compile Permissions

We are new Pro*C users and are struggling with the database permissions necessary to compile a program. We want to define a standard make file with a standard Oracle user and password. Ideally this user should have only CONNECT permission. But it seems that whenever we call a stored procedure, the user must have EXECUTE permission on that procedure. This means that we'd have to grant EXECUTE on every procedure that our C programs use to this standard user. Does anybody know why it's necessary for Pro*C to execute a procedure in order to compile a program that calls it? Are there any Pro*C compile options that allow us to avoid this? We are using Oracle 8.1.5 on Solaris 2.6.

Thanks.

Gary Sadler
Polygon Network

--== Sent via Deja.com http://www.deja.com/ ==-- ---Share what you know. Learn what you don't.--- Received on Wed May 19 1999 - 13:28:26 CDT