Re: Creat trusted user
From: Dan Guzman (danguzman_at_nospam-earthlink.net)
Date: 07/31/04
- Previous message: F_ps10: "Creat trusted user"
- In reply to: F_ps10: "Creat trusted user"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Sat, 31 Jul 2004 11:34:03 -0500
By 'trusted user' I assume you mean an existing Windows account. You can
grant a Windows account permissions to connect to SQL Server using
sp_grantlogin:
EXEC sp_grantlogin 'MyDomain\MyAccount'
You can then grant the account access to a particular database using
sp_grantdbaccess:
USE MyDatabase
EXEC sp_grantdbaccess 'MyDomain\MyAccount'
The user will also need object permissions. This is normally accomplished
by creating roles, granting object permissions to roles and using role
membership to control user object access.
EXEC sp_addrole 'MyRole'
GRANT SELECT ON MyTable TO MyRole
EXEC sp_addrolemember 'MyRole', 'MyDomain\MyAccount'
-- Hope this helps. Dan Guzman SQL Server MVP "F_ps10" <f_ps510@yahoo.uk.co> wrote in message news:%2347s2mxdEHA.3732@TK2MSFTNGP11.phx.gbl... > hi every one , > I used many different way to creat trusted user in SQL Server2000 runing on > WinServer2003 but any of them din't work!!! > Do u have any suggestion ?!? > >
- Previous message: F_ps10: "Creat trusted user"
- In reply to: F_ps10: "Creat trusted user"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
