Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: create table grants and Dynamic SQL question
Jim Kennedy wrote:
>>given 2 users a and b, I would like to do the following:
>>
>>connect a/password_at_instance
>>create table b.test (x number);
>>drop table b.test;
>>
>>Is this possible in Oracle 9.2, and if yes, which grants will I have to
> > set? >
Well ... no, I don't need it absolutely - but it would represent the design of my application, to seperate things that should be seperated.
> This is not MS SQL Server or Sybase.
I haven't worked with MS SQL nor with Sybase, so I have no idea what you're trying to tell me.
> But if you really, reallly think you need > to do something like this then use global temporary tables (see > documentation or asktom.oracle.com and do a search). Then you don't have to > do the whole create table dance.
Nope, as I wrote I need persistent tables that last way longer than just one session. The drop table statement above was just shown for completeness.
Stephan Received on Mon May 24 2004 - 04:07:53 CDT
![]() |
![]() |