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