Re: Table Creation Question.

User A must have CREATE ANY TABLE privilige otherwise you would not be able to create B.table_name.
Having this privilige allows A to do a DESC B.table_name but does not allow A to manipulate the data in B.table_name for that you need to grant the appropriate priviliges which you correctly identified.

You cannot have any schema accessing any other schema's objects without any controls.

hth
Lawrence

"Praveen Mohan Mohanan" <Praveen.Mohanan_at_Sun.COM> wrote in message news:3B7DAA41.409D507A_at_Sun.COM...
>
>
>
> Hi..All,
>
> Say I have 2 different users in the same db. A & B
>
> I can create a table by logging as A & create a table under B
>
> i.e
> - Login as A
> CREATE table B.table_name
> (
> ..........
> )
>
>
> I have a procedure stored under user A. When it tries to access the
> table B.table_name , it gives me an error table or view not found. It
> works only if I give grant Insert & select on table B.table_name to A.
>
> My question if I can create the table under some other user why can't I
> access the table in my SP. Where as I can do
>
> desc B.table_name & get the results from user A
>
> the table B.table_name is created dynamically by user A.
>
>
> --
>
> Regards,
>
> Praveen Mohanan
>
Received on Fri Aug 17 2001 - 22:16:05 CDT