Creating views with procedures, help!

From: Jose M. <jmjulia_at_arrakis.es>
Date: Wed, 08 Jul 1998 16:06:01 +0200
Message-ID: <35A37CC8.B7FCDBE7@arrakis.es>

Hi!

I've got a problem programming in PL/SQL and I hope someone can give me some clues...

I have a procedure which creates a view. It does this creating a string like
"Create view ... as select * ... etc.", and executing that string using dbms
commands. But I want some other users to use the procedure, so I've created a public synonym on it, and I've granted execution on it to that users.

Suppose the procedure's owner is called vader, and another user is called luke. When luke uses the procedure to create that view, it's created ok, but its owner is vader, like the procedure! And I want it to be luke's, because it's luke who runs the procedure and he should be the owner of that view, isn't it? How can I do it?

I've tried to change the "create view my_view" statement inside the procedure to "create view luke.my_view.." but it doesn't work... any tip?

Thanx in advance!!!
--

---

Jose M. Julia' (Seldon_ on IRC) -- Madrid (Spain) e-mail: jmjulia_at_arrakis.es
www: http://www.arrakis.es/~jmjulia

---

"Violence is the last refuge of the incompetent"
("La violencia es el ultimo recurso del incompetente")

                            Isaac Asimov
_____________________________________________________

Received on Wed Jul 08 1998 - 09:06:01 CDT