Re: Granting a user access to Enterprise Manager

From: Barry McAuslin (barry_mcauslin@nospam.yahoo)
Date: 06/25/02 

From: "Barry McAuslin" <barry_mcauslin@nospam.yahoo>
Date: Tue, 25 Jun 2002 13:20:33 +0100

Give them the Security Administrator server role and the db_securityadmin
database role.

Barry McAuslin

"Abul" <abul@elekta.com> wrote in message
news:11d0a01c21c2c$088c0cd0$9ae62ecf@tkmsftngxa02...
> Hi,
>
> I would like to grant a user to access Enterprise manager
> so that thay can create user account and manage their
> database. I do not want them to have access to anything
> else. What is the best way to achieve this. I am using SQL
> Server 7.0 on Windows NT 4.0
>
> Please let me know.
>
> Thanks in advance.
>
> Abul

Loading