Removing users from database

[Hall]

PWA allows de-activating user IDs but not removing them.

We have a bit of a mess with our user IDs and need to clean up.

Can anyone tell me how to remove users from the database? Does that require
SQL? If so, what statement(s) would do it?

 

[William Raymond]

Hi Hall,

As you have already figured out, you cannot delete resources. Aside from
writing a script to do this or finding one that might exist out there
already, I would recommend you do one of the following:


Option 1 (best bet): Place the inactive users into an RBS structure called
"Inactive" (or something to that affect) and modify your reports and views
to filter out those inactive resources.

Option 2 (not recommended): Create a dummy 'deleted resource' account and
merge all inactive resources with this one.

You can also call Microsoft Support and see if there is anything else they
can offer you.

-Bill
--
Microsoft Project MVP
http://www.capstone.com
wraymond at capstone dot com

Project FAQs: http://www.mvps.org/project/

 

[Greg Horodeck]

Take a look at the following page which has a script for deleting resources.

http://www.microsoft.com/technet/prodtechnol/project/project2002/reskit/ps02
/psmgmt/pscustom.asp





Greg Horodeck





Hi Hall,

As you have already figured out, you cannot delete resources. Aside from
writing a script to do this or finding one that might exist out there
already, I would recommend you do one of the following:


Option 1 (best bet): Place the inactive users into an RBS structure called
"Inactive" (or something to that affect) and modify your reports and views
to filter out those inactive resources.

Option 2 (not recommended): Create a dummy 'deleted resource' account and
merge all inactive resources with this one.

You can also call Microsoft Support and see if there is anything else they
can offer you.

-Bill
--
Microsoft Project MVP
http://www.capstone.com
wraymond at capstone dot com

Project FAQs: http://www.mvps.org/project/

 

[Abraham]

Hello,

I followed the instructions from TechNet for deleting
resources. After doing so, the deleted resources still
appear in the Portfolio Analyzer, even after regenerating
my OLAP Cube.

 

[Kevin Flanagan]

Did you make sure you deleted those resources out of the
projects where the cube is actually built from?