How to remove or disable user account using FBA ( SQL Authentication ) on a MOSS 2007?

We have a MOSS 2007 installed with a multiple of site collections with FBA ( SQL Authentication ) enabled and now HR wants to remove or disable one user account from both SharePoint 2007 and SQL Membership database and which way is the easiest way to perform?
AngusvickiAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

GeorgeGerguesCommented:
There are so many ways to do that

The Account (authentication ) reside in SQL DB . you can manage that depending on the which tool you use to create the account. - you use CKS , from codeplex or an inhouse tool ?

The Profile can be removed from the Central Admin - Shared Services - > Profile Manager

Those are two separate things

but If you want to disable the user (and that is something you should do first ,) you can check the table in the ASPNET database on sql server to set that to disabled.


last , You can simply make sure the account is not part of any groups on the sharepoint site and that should remove him/her from access.


Best of luck
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
AngusvickiAuthor Commented:
Thanks George,

Q1. If I want to disable the user first, could I use SQL Management Studio to do it instead of using SQL Query?

Q2. I think I could find the ASPNET database name ( we lost the documentation ) from the Central Administration Web.config, right?

Q3. If the user I am going to disable is the user we added initially from the ASP.NET Web Site Admin Tool in order to connect membership data store, do you think it does matter?
0
GeorgeGerguesCommented:
OK  

Now be carefull here , this can be tricky

You can disable or change password using SQL  management

It is recommended to use Stored procedures on that dababase than just sql calls.

DB name by default would be ASPNET
you will find that in the web.config on the site itself.

the stored procedure is

 - Membership_UpdateUser

and to disable the account would be .
Is allowed = 0 or no or false etc.


I am sure you have some tool inside you site collection under user administration that would allow you to do that .

in any case the store procedure should do the trick

but it update the IsApproved column in the  [Membership] Table

Best of luck

0
Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

AngusvickiAuthor Commented:
Thanks again, George,


Is it possible to use ALTER LOGIN [user name] DISABLE to disable the user account so that I can revert in case of something happens?
0
GeorgeGerguesCommented:
I would change both the user name and email and make sure they are unique.
0
AngusvickiAuthor Commented:
The user account we are going to disable is the user going to be terminated by HR so that we don't really care about email but we do concern about that user account may have impact with something elase so that is it possible to run the sql query from the ASPNET database as "ALTER LOGIN [user name] DISABLE" to disable that specified user account?  
0
GreatGermCommented:
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SharePoint

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.