Re: How to grant table access to

tim.hall_at_tswi.com (Tim Hall ) wrote:
[snip]
>
>That's a simple one:
>
>When accessing USR1_TABLE from USER2 (or vice-versa), you need to
>quality the table with the user name:
>
>SELECT * FROM USER1.USR1_TABLE;
>
>Alternatively, you could create a synonym.
My users forgot to issue a COMMIT (in SQL/PLUS) as well, so they couldn't see the others users data even with the owner preceeding the table name.

Kevin

-- 
                      \\///
                      (0-0)
           +----oOO----(_)-----------+
           |       K. E. Fein        |
           |    Database Analyst     |
           |   kfein_at_primenet.com    |
           +------------------oOO----+
                     |  |  |
                     |__|__|
                      || ||
                     ooO Ooo