sp_adduser 2 times in a row ?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Barb - 24 Aug 2006 21:03 GMT

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

Reply to this Message

Hari Prasad - 25 Aug 2006 13:15 GMT

Hi,

For adding the role you have to use the system procedure sp_addrolemember.

EXEC sp_addrolemember HR, 'Vidur'

Thanks
Hari
SQL Server MVP

> Hi,
>
[quoted text clipped - 8 lines]
> Thanks.
> Jack

Reply to this Message

Dan Guzman - 25 Aug 2006 13:47 GMT

> EXEC sp_adduser 'Vidur', 'Vidur', 'HR'?
> The user will be updated with this new role?

No, you will get an error because the user already exists.

Keep in mind that a user can be a member of multiple roles. The sp_adduser
@grpname parameter is only for convenience when adding a new user. Use
sp_droprolemember to remove membership and sp_addrolemember to add a user to
a role.

Signature

Hope this helps.

Dan Guzman
SQL Server MVP

> Hi,
>
[quoted text clipped - 8 lines]
> Thanks.
> Jack

Reply to this Message