Posted by David on 11/30/06 22:20

Hi all,

You're all stars, really helpful. Maybe one day i can be :)

My question is regarding the authentication in Windows SQL Server 2005.

We have setup a sa account. We purchase software from a third party
that runs on it. Before their software logs on the sql server as sa,
and does its own access control, windows autentication takes over. Its
logs users on correctly i guess, using a more secure link via the
domain. However, I am probably blind, but where can we assign rights to
each domain user? I.e. stop XXY dropping tables, but allow ABC to drop
tables?

I had a brief look through but could not find anything that stood out,
in the SQL Manager.

Thanks

David

P.S This is SQL Server 2005 Workgroup edition running on a 2003 windows
domain server. Alongside a SQL 2000 server, which is running fine using
sa accounts.

For those in the same timezones as me... have a good evening.

[Back to original message]