Re: sp_adduser 2 times in a row ?
- From: "Hari Prasad" <hari_prasad_k@xxxxxxxxxxx>
- Date: Fri, 25 Aug 2006 07:15:26 -0500
Hi,
For adding the role you have to use the system procedure sp_addrolemember.
EXEC sp_addrolemember HR, 'Vidur'
Thanks
Hari
SQL Server MVP
"Barb" <Barb@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:012A13FC-5EAA-4AFF-94C0-8F5F5E86DDB7@xxxxxxxxxxxxxxxx
Hi,
I did EXEC sp_adduser 'Vidur', 'Vidur', 'Recruiting'
And now I see the user Vidur.
What will happen if I'm doing
EXEC sp_adduser 'Vidur', 'Vidur', 'HR'?
The user will be updated with this new role?
Thanks.
Jack
.
- Prev by Date: sa spid - need to kill - server hanging
- Next by Date: Re: sp_adduser 2 times in a row ?
- Previous by thread: sa spid - need to kill - server hanging
- Next by thread: Re: sp_adduser 2 times in a row ?
- Index(es):
