how to create a user with sa privilege

[Zak Monde]

Using SQL 6.5 SP4.
TIA.
Zak

[Craig]

On 2/16/99 7:56:48 AM, Zak Monde wrote:
> Using SQL 6.5 SP4.
TIA.
Zak

+++++++
I am not aware of any way to do this. The best you can do is give them DBO and privelages to do the stuff they need. If you find a way to do this, post it because I would like to know this myself.........Craig

[patrick.fediere]

You could use Security Mgr. then grant to SA , users or Groups.
Sec.Mgr will create the regular login(s) in SqlServer then the user will be able to connect with 'trusted connection' and inheritate of the privileges of SA, I mean without any password in Sql. The password and the user name are the ones coming from NT.

In SqlServer Security options you must be in 'Integrated or Mixed'.
If you want to understand more, you could run a SqlTrace on the server you are acting, then use Sec.Mgr to grant users or Nt Group. (xp_grantlogin , xp_logininfo, ...)

Bye Patrick
On 2/16/99 7:56:48 AM, Zak Monde wrote:
> Using SQL 6.5 SP4.
TIA.
Zak