<div>
connect to your server with the account sa, and execute the following script:<br />
USE MASTER<br />
GRANT EXECUTE ON sp_addlogin TO x<br />
GRANT EXECUTE ON sp_adduser TO x<br />
<br />
CHeers
</div>


connect to your server with the account sa, and execute the following script:
USE MASTER
GRANT EXECUTE ON sp_addlogin TO x
GRANT EXECUTE ON sp_adduser TO x

CHeers

<div>
I still get <br />
User does not have permission to perform this action.<br />
on sp_Addlogin<br />
when I switch to another database and try and add users<br />
<br />

</div>


I still get
User does not have permission to perform this action.
on sp_Addlogin
when I switch to another database and try and add users



<div>
deestuar: <br />
This old question needs to be finalized -- accept an answer, split points, or get a refund. &nbsp;For information on your options, please click here-&gt; <a href="http:/help/closing.jsp#1" rel="ugc">http:/help/closing.jsp#1</a>&nbsp;<br />
EXPERTS:<br />
Post your closing recommendations! &nbsp;No comment means you don't care.
</div>


deestuar:
This old question needs to be finalized -- accept an answer, split points, or get a refund.  For information on your options, please click here-> http:/help/closing.jsp#1 [http:/help/closing.jsp#1] 
EXPERTS:
Post your closing recommendations!  No comment means you don't care.

<div>
No comment has been added lately, so it's time to clean up this TA.<br />
I will leave a recommendation in the Cleanup topic area that this question is:<br />
<br />
Award points to nigelrivett<br />
<br />
Please leave any comments here within the next seven days.<br />
<br />
PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER!<br />
<br />
Anthony<br />
EE Cleanup Volunteer
</div>


No comment has been added lately, so it's time to clean up this TA.
I will leave a recommendation in the Cleanup topic area that this question is:

Award points to nigelrivett

Please leave any comments here within the next seven days.

PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER!

Anthony
EE Cleanup Volunteer

<div>
<div class="content wysiwyg-content">
Using sql server 7<br />
<br />
I have a user x whoes login name is x<br />
who has permissions of<br />
public,db_owner,db_accessa<wbr />dmin,db_se<wbr />curityadmi<wbr />n<br />
<br />
It seems that only the sa account can call the sp_addlogin,sp_adduser.<br />
<br />
Is there anyway I can give permissions to my account x to do this<br />
<br />
TIA
</div>
</div>


Using sql server 7

I have a user x whoes login name is x
who has permissions of
public,db_owner,db_accessadmin,db_securityadmin

It seems that only the sa account can call the sp_addlogin,sp_adduser.

Is there anyway I can give permissions to my account x to do this

TIA

permissions problem

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.