add new user with all rights to all dbases

Kind of new to Enterprize Manager, just wondering what the steps are to add a
new user that will have all rights to all databases? Thanks.
--
Paul G
Software engineer."Paul" <Paul@.discussions.microsoft.com> wrote in message
news:FF651560-0FE5-4B24-B9C2-C66E227CD0FB@.microsoft.com...
> Kind of new to Enterprize Manager, just wondering what the steps are to
> add a
> new user that will have all rights to all databases? Thanks.
> --
> Paul G
> Software engineer.
Add your new user normally. Either as a Windows Authenticated account or as
a SQL User account.
Add that new user to the sysadmins SQL Server group inside SQL Server.
Just a side note on security here. I hope that this is the user account
that you will be connecting with moving forward and not something you are
planning on giving to everyone who uses the database. ;-)
Rick Sawtell
MCT, MCSD, MCDBA|||Thanks for the response. Actually I was trying to set up an account for a
database administrator that could administer all dbases. This would only be
used by one individual.
"Rick Sawtell" wrote:
> "Paul" <Paul@.discussions.microsoft.com> wrote in message
> news:FF651560-0FE5-4B24-B9C2-C66E227CD0FB@.microsoft.com...
> > Kind of new to Enterprize Manager, just wondering what the steps are to
> > add a
> > new user that will have all rights to all databases? Thanks.
> > --
> > Paul G
> > Software engineer.
> Add your new user normally. Either as a Windows Authenticated account or as
> a SQL User account.
> Add that new user to the sysadmins SQL Server group inside SQL Server.
>
> Just a side note on security here. I hope that this is the user account
> that you will be connecting with moving forward and not something you are
> planning on giving to everyone who uses the database. ;-)
>
> Rick Sawtell
> MCT, MCSD, MCDBA
>
>|||If it is OK to have sysadmins privileges for the person, just add a login for the person, and make
it sysadmin.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"Paul" <Paul@.discussions.microsoft.com> wrote in message
news:6401A53E-E9C0-41F9-9E08-C58B82148BD0@.microsoft.com...
> Thanks for the response. Actually I was trying to set up an account for a
> database administrator that could administer all dbases. This would only be
> used by one individual.
> "Rick Sawtell" wrote:
>> "Paul" <Paul@.discussions.microsoft.com> wrote in message
>> news:FF651560-0FE5-4B24-B9C2-C66E227CD0FB@.microsoft.com...
>> > Kind of new to Enterprize Manager, just wondering what the steps are to
>> > add a
>> > new user that will have all rights to all databases? Thanks.
>> > --
>> > Paul G
>> > Software engineer.
>> Add your new user normally. Either as a Windows Authenticated account or as
>> a SQL User account.
>> Add that new user to the sysadmins SQL Server group inside SQL Server.
>>
>> Just a side note on security here. I hope that this is the user account
>> that you will be connecting with moving forward and not something you are
>> planning on giving to everyone who uses the database. ;-)
>>
>> Rick Sawtell
>> MCT, MCSD, MCDBA
>>
>>|||ok thanks for the additional information.
"Tibor Karaszi" wrote:
> If it is OK to have sysadmins privileges for the person, just add a login for the person, and make
> it sysadmin.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> http://www.sqlug.se/
>
> "Paul" <Paul@.discussions.microsoft.com> wrote in message
> news:6401A53E-E9C0-41F9-9E08-C58B82148BD0@.microsoft.com...
> > Thanks for the response. Actually I was trying to set up an account for a
> > database administrator that could administer all dbases. This would only be
> > used by one individual.
> >
> > "Rick Sawtell" wrote:
> >
> >>
> >> "Paul" <Paul@.discussions.microsoft.com> wrote in message
> >> news:FF651560-0FE5-4B24-B9C2-C66E227CD0FB@.microsoft.com...
> >> > Kind of new to Enterprize Manager, just wondering what the steps are to
> >> > add a
> >> > new user that will have all rights to all databases? Thanks.
> >> > --
> >> > Paul G
> >> > Software engineer.
> >>
> >> Add your new user normally. Either as a Windows Authenticated account or as
> >> a SQL User account.
> >>
> >> Add that new user to the sysadmins SQL Server group inside SQL Server.
> >>
> >>
> >> Just a side note on security here. I hope that this is the user account
> >> that you will be connecting with moving forward and not something you are
> >> planning on giving to everyone who uses the database. ;-)
> >>
> >>
> >>
> >> Rick Sawtell
> >> MCT, MCSD, MCDBA
> >>
> >>
> >>
> >>
>
>