managing NT group accout

background: sql2k on nt5
can anyone tell me is it possible to assign nt accounts (such as NtUser1,
NtUser2,NtUser3) to a role? instead of a SQL NT group?
Role is located under databases/roles, NT group is located under
security/logins
thank you.
Hi,
Yes, It is possible to add a NT / OS user to access the SQL Server and
assign any roles. You can either use Enterprise manager -- Security --
Addlogin
or use the below commands in Query analyzer:-
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 creaed inside the database
go
sp_addrolemember role,'dbusername' -- THis is database wide role
Thanks
Hari
MCDBA
"== Steve Pdx==" <lins@.nospam.portptld.com> wrote in message
news:emy#dVsPEHA.2452@.TK2MSFTNGP11.phx.gbl...
> background: sql2k on nt5
> can anyone tell me is it possible to assign nt accounts (such as NtUser1,
> NtUser2,NtUser3) to a role? instead of a SQL NT group?
> Role is located under databases/roles, NT group is located under
> security/logins
> thank you.
>