I just found a way around it. If you use JTDS as your driver, you can
specify your domain, and log in using windows authentication instead
of SQL authentication, which makes things a whole heap easier.
Thankyou JTDS!!!

On Feb 6, 10:46 am, "jamo" <nzj...@gmail.com> wrote:
> Hello people,
>
> Im new to MS SQL server and I'm trying to port a MySQL based app to
> run on an existing SQLServer. Its proving somewhat more difficult that
> I first thought, due to the fact that MS SQL wont let a user select
> another users table, without specifing the user in the SQL command.
>
> Can you set up a windows user account that can login via SQL server
> authentication (i.e specify user "Guest" on the jdbc connection
> string, that has the same privilates as the "Guest" windows login
> account)?
>
> If this isnt possible, is there a SQL command that you can use that
> will make all subsequent commands in the context of that user? For
> example, if I could go "SET USER dbUser;" "SELECT * FROM hisTable"...
> which would execute the same as "SELECT * FROM dbUser.hisTable".
>
> Am I going about this competely the wrong way?
>
> Any would be much appreciated!!!
>
> Regards,
>
> Jamo.