Solved

permissions problem

Posted on 2001-08-16
6
651 Views
Last Modified: 2007-12-19
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
0
Comment
Question by:deestuar
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
6 Comments
 
LVL 143

Expert Comment

by:Guy Hengel [angelIII / a3]
ID: 6392086
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
0
 
LVL 1

Author Comment

by:deestuar
ID: 6392718
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

0
 
LVL 18

Accepted Solution

by:
nigelrivett earned 50 total points
ID: 6433137
only members of sysadmin and securityadmin roles can execute this so you would have to put your user in one of these groups.
That's the server role not the database role you have put it in the database role.
0
 

Expert Comment

by:CleanupPing
ID: 9281792
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 
EXPERTS:
Post your closing recommendations!  No comment means you don't care.
0
 
LVL 75

Expert Comment

by:Anthony Perkins
ID: 9807326
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
0

Featured Post

Visualize your virtual and backup environments

Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Everyone has problem when going to load data into Data warehouse (EDW). They all need to confirm that data quality is good but they don't no how to proceed. Microsoft has provided new task within SSIS 2008 called "Data Profiler Task". It solve th…
Ever wondered why sometimes your SQL Server is slow or unresponsive with connections spiking up but by the time you go in, all is well? The following article will show you how to install and configure a SQL job that will send you email alerts includ…
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
Via a live example, show how to setup several different housekeeping processes for a SQL Server.

734 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question