Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Table Creation Question.
Would you explain or expand on your point. I am not sure what you are trying
to show or achieve as it looks to me that you are describing the normal
security within oracle. Only sys and system have the privilage to access any
object and even that can be restricted. Users dont in general have
permissions on other users objects unless the are granted them e.g. GRANT
SELECT TO A ON B.table_name.
Talk to your DBA and ask how the A and B accounts are set up. I am asuming A and B synonms for real acounts in your organisation.
Neil
"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 Tue Aug 21 2001 - 11:31:54 CDT