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.