We help IT Professionals succeed at work.
Get Started

Sql Server 2000 - Extract llist of users, and their permissions/groups on each database

855 Views
Last Modified: 2012-05-09
Hello,  

We are finally in a position to upgrade our business system server from 2000 to 2005. ( we cannot go any higher yet as the system needs to support an old version of uniface).

The server chaps are asking  me for:

the details of any user accounts you require creating on the new SQL 2005 , we need username, password, database and permissions level.

This server supports a main massive application, a 2nd large database for another 3rd party app, and several database which have been built by various departments for various web apps and other systems.

There are about 800 user accounts, 10 databases of various sizes, and a host of automated jobs, stored procedures or other scripts.

Is it possible to extract a list of the users on the DB using SQL? i'll need to list all the accounts, and analyse their permissions on each database, and if possible produce a script which can create them or at least assign their groups and permissions... which can be run on the new 2005 server once the databases have been imported.
Comment
Watch Question
Top Expert 2010
Commented:
This problem has been solved!
Unlock 1 Answer and 2 Comments.
See Answer
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE