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.

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.