RE: errors with CREATE SYNONYM procedure

2002-05-10 Thread Mercadante, Thomas F
Bill, Does the OWNER of the proc have CREATE PUBLIC SYNONYM system priv? Tom Mercadante Oracle Certified Professional -Original Message- Sent: Friday, May 10, 2002 11:24 AM To: Multiple recipients of list ORACLE-L I've developed a procedure that will create a public synonym on an

RE: errors with CREATE SYNONYM procedure

2002-05-10 Thread Magaliff, Bill
That was it - thanks! Forgot there were two distinct system privs - CREATE ANY SYNONYM and CREATE PUBLIC SYNONYM -Original Message- Sent: Friday, May 10, 2002 10:38 AM To: '[EMAIL PROTECTED]' Cc: '[EMAIL PROTECTED]' Bill, Does the OWNER of the proc have CREATE PUBLIC SYNONYM system