If I have an execute privilege on a procedure in another users schema, can I execute his procedure even though I do not have privileges on the tables within the procedure?
Yes, it can be executed.
Which of the following is not a schema object: Indexes, tables, public synonyms, triggers and packages?