Re: Windows Authentication

From: Hari (hari_prasad_k_at_hotmail.com)
Date: 05/26/04 

Date: Wed, 26 May 2004 21:16:11 +0530

Hi,

It seems you have done every thing perfectly.

Can you try the below from query Anlayzer:

EXEC sp_grantlogin [domain\os_user]
go
sp_addsrvrolemember [domain\os_user],'srv_role'
go
use <dbname>
go
EXEC sp_grantdbaccess 'domain\OS_USER', 'dbusername' -- dbusername - This
will create user inside the database
go
sp_addrolemember 'db_owner','dbusername' -- THis is database wide role

After this try to access the tables.

Thanks
Hari
MCDBA

"JLFleming" <anonymous@discussions.microsoft.com> wrote in message
news:12a8e01c4431e$4f1e1d30$a001280a@phx.gbl...
>
> I would like to give a user dbo rights to a few
> databases, using Windows NT authentication.
>
> I did the following:
>
> 1) Gave there domain username access to the SQL server
> 2) Gave him access to necessary databases
> 3) Gave him dbo rights in each database
>
> After doing this, they were not able to update any data
> in the tables.
>
> Is there something else I need to do?
>
> Thank you,
> JLFleming

Relevant Pages