Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> 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 Received on Tue Jun 06 2000 - 15:13:25 CDT