Re: SQL Server 2005 Windows Authentication mapping to Logins
- From: Sue Hoegemeier <Sue_H@xxxxxxxxxxxxx>
- Date: Thu, 26 Oct 2006 17:50:40 -0600
Why do you want to give ordinary users sysadmin privs?
That's pretty dangerous.
Anyway...you add windows users or groups as SQL Server
logins by using CREATE LOGIN. For example:
CREATE LOGIN [YourDomain\YourGroup] FROM WINDOWS
If the group is one of the built in standard groups on the
local box, you would use BUILTIN for the domain. For
example, to add the local administrators you would use:
CREATE LOGIN [BUILTIN\Administrators] FROM WINDOWS
-Sue
On Mon, 23 Oct 2006 10:46:02 -0700, Chem Finder
<ChemFinder@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:
I configured SQL Server 2005 Express to use Windows authentication. I want
to give ordinary users sysadmin privileges. How do you map Windows groups
to SQL Server logins? There appears to be one Login, BUILTIN\Users. Members
of the Administrators group of the machine have full access, but members of
the Power Users Groups are logged into SQL Server as 'guest.' How are
Windows Authentication logins mapped to SQL Server logins?
.
- Prev by Date: Is there an alternative to disabling windows authentication?
- Next by Date: Re: Disable database diagram creation
- Previous by thread: Re: SQL Server 2005 Windows Authentication mapping to Logins
- Next by thread: SQL2K Linked Svr Login Impersonation
- Index(es):
Relevant Pages
|
|
