Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.tools -> Re: Writing to tables as different use.
On Thu, 11 May 2000 18:57:33 GMT, rspeaker_at_my-deja.com wrote:
>it sounds as if you have UserA created a table called emp, and UserB
>created a table called emp. These are not the same table. They are
>defined to the database by the schema, so you have UserA.emp and
>UserB.emp. By default, inserts done by UserA will go into UserA.emp and
>inserts done by UserB will go into UserB.emp. UserA will not be able to
>insert into UserB.emp, nor will UserB be able to insert into UserA.emp.
>Unless you give the users explicit insert rights (UserA issues grant
>insert on emp to UserB, and UserB does the same for UserA). At that
>point, the insert command should then become insert into UserB.emp
>values ('a','b') etc. or insert into UserA.emp values ('a','b') to
>specify which table you want the inserts to go in.
>
>HTH,
>Roy
OK, it looks like I need to do a commit at the end of a session. I figured it was done automatically.
Brian Received on Thu May 11 2000 - 00:00:00 CDT
![]() |
![]() |