June 27, 2007

How to set user's home page?

I got a request that all users of CRM must have their first page set to announcements.

Of course I could write a mail to all users requesting them to change their page in settings page to announcements, but this is a no no way.

So I searched the SQL database and found a user settings table in _MSCRM database. Just set the HomepageSubarea of the table UserSettingsBase to the value 'nav_news'.

So if you want to set announcements as a home page for all users just run the query:

UPDATE [UserSettingsBase] SET [HomepageSubarea] = 'nav_news', [HomepageArea] = 'Home'

Although it works in my installation, this is not a supported change, so you are doing it at your own risk. Do backup the database before messing with it. Just in case.

1 comment:

Anonymous said...

Just a note, you'll have to do an iisreset for the changes to take place. The original settings are cached.