Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How to create a table in another user
Write a stored procedure (PL/SQL) in user2 space, that creates the
table. Grant execute on this procedure to user 1. User1 calls
user2.procedurename.
Benny Yazdanpanahi wrote:
>
> I have an sql which i am running from user1 ( e.g.)
>
> and in that SQL i am trying to create a temporary table in another user
> e.g. user2 )
>
> but user1 does not have "create any table priviledge"
>
> and DBA does not wants me to write any connect statement in my sql to
> connect to user2
> and do create table statement because of security issue !!
>
> Can anyone send me suggestion.
>
> Thanks
Received on Fri Jun 18 1999 - 11:53:08 CDT