Message-Id: <10520.107956@fatcity.com> From: "Gait, Christopher" Date: Tue, 6 Jun 2000 16:13:25 -0400 Subject: Global temporary table procedure permissions problem I have a procedure for creating global temporary tables from queries which compiles okay. The same code works fine as an anonymous block. But when I call the procedure I get a permissions error. The only thing I can think is that temporary tables, by their nature, are using facilities managed by SYS (TS# and temporary segments), and thus there is a permission problem. It is not surprising that I don't get an error on creating the procedure, however, since temporary tables are so new there probably isn't a whole lot nailed down behind the scenes in 8i for using them. Our environment. Oracle version 8.15, running on DEC Alphas with Digital 4.0d. Tables are created by a DBA user (me to be precise) in his temp