Re: managing msde with nt authentication
From: Dan Guzman (guzmanda_at_nospam-online.sbcglobal.net)
Date: 09/24/04
- Next message: CMLC: "BUILTIN\Administrators help"
- Previous message: Ed Johnson: "managing msde with nt authentication"
- In reply to: Ed Johnson: "managing msde with nt authentication"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Thu, 23 Sep 2004 23:02:38 -0500
By default, only members of the local administrators group can access SQL
Server. You can grant non-admin users access with sp_grantlogin:
EXEC sp_grantlogin 'MyComputer\MyUser'
Then, add the user to any databases needed using sp_grantdbaccess:
USE MyDatabase
EXEC sp_grantdbaccess 'MyComputer\MyUser'
Finally, add the users to database roles as desired:
USE MyDatabase
EXEC sp_addrolemember 'MyRole', 'MyComputer\MyUser'
Of course, you'll also need to GRANT the user or role any database
permissions needed:
GRANT SELECT ON MyTable TO MyRole
-- Hope this helps. Dan Guzman SQL Server MVP "Ed Johnson" <nospam@nospam.com> wrote in message news:eOrV5ceoEHA.3524@TK2MSFTNGP10.phx.gbl... >I have my program running right now on sqlserver authentication because it > was easy to maintain and seemed to get around the need for managing user > rights in a domain. But I wanted to know the practical steps of how to > change my application to use nt authentication. Do I have to be on a > domain > to use nt authentication? I know that you can't use NT authentication on > Win9x OSes. If my clients are running on Windows NT derivatives and they > are > all running local MSDE databases on their on computers, how do I manage > their logons using NT integrated security? Do I have to add them to the > sqlserver user database? It seems like when I used a logon with admin > rights > I did not have to do that, but when a customer logged on with only power > user rights in the domain that they could not use nt authentication - is > that because I did not have their name in the mssql server database user > list? How do I maintain security for MSDE on a local instance using NT > authentication? Thanks for any advice? > > From: Ed > >
- Next message: CMLC: "BUILTIN\Administrators help"
- Previous message: Ed Johnson: "managing msde with nt authentication"
- In reply to: Ed Johnson: "managing msde with nt authentication"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
