Hi there, I'm new to using global temporary tables in Oracle. I'm using Ora cle 10g R2. I have multiple schema's in the database. Each schema has its own set of database objects (tables, views, procedures ... etc). One of the schemas has a global temporary table which is filled with a stored procedure. If I want to use the global temporary table and the stored procedure in another schema ( or maybe more schemas in the future) what is the best practice? Is it better to grant insert, select, update, delete rights on the temporary table to the other schemas or should I create the global temp table for the other schema(-s)? Thanks in advance.