Re: Table Creation Question.

In article <3B7DAA41.409D507A_at_Sun.COM>, Praveen says...
>
>
>
>
>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
>

see
http://osi.oracle.com/~tkyte/Misc/RolesAndProcedures.html

user a has the CREATE ANY TABLE priv (most likely via a role) and apparently SELECT ANY TABLE (definitely via a role)

--
Thomas Kyte (tkyte@us.oracle.com)             http://asktom.oracle.com/ 
Expert one on one Oracle, programming techniques and solutions for Oracle.
http://www.amazon.com/exec/obidos/ASIN/1861004826/  
Opinions are mine and do not necessarily reflect those of Oracle Corp