Re: what permission are needed to have constrainst across schemas?

 Hi !

You need to grant the "select table_name" directly to the user which will reference to another schema in a procedure.

 Regards,

 Mario Bucsics

• Sent from RemarQ http://www.remarq.com The Internet's Discussion Network * The fastest and easiest way to search and participate in Usenet - Free!