Set Default Area for MS CRM User

Most of the time we want to change default area for all the crm user, but if number of users are very large then it’s a time consuming process, every body need to login and need to change his/her default page area.

There is not any supported method to chage it for all the users but we can do this by unsupported way :p

Inorder to change default page we need to update two columns in UserSettingsBase table

1. Homepagearea

2. Homepagesubarea

for example we want to make ‘Announcements’ as default page for all the user in that case just run this query under your organization database and reset IIS.

update UserSettingsBase set Homepagearea=’Workplace’,Homepagesubarea=’nav_news’

 Happy codding

Leave a comment

Filed under Sql Server & Ms CRM 4.0

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s