- Revoked Admin role in CRM 1.2
- Posted by Jouko on July 19th, 2004
Hello!
I have a client who installed MS CRM 1.2 standard and put
the administrator role on one of the users. Then he
rovoked the administrator role from the user (by
mistake...) and the result is that the CRM-system does
not have an administrator any more.
Is there any one that has an idea of what to do?
Thank you!
//Jouko from Sweden
- Posted by John O'Donnell on July 19th, 2004
Scan the archives on this group on google.com as this has come up before.
The only way to fix this is to go into the database and restore the admin
role.
--
John O'Donnell
Microsoft CRM MVP
"Jouko" <anonymous@discussions.microsoft.com> wrote in message
news:073601c46db2$37d5c7e0$a501280a@phx.gbl...
- Posted by Matt Parks on July 19th, 2004
Jouko,
You need to look at the following tables in the _MSCRM database:
SystemUserBase
SystemRoleBase
SystemUserRole
You basicall need to add a record to the SystemUserRole table to reflect the
proper user/role combination to put a user into that role.
Be very careful when editing this table as you can have unexpected results if
you modify the wrong record. I would highly recommend a complete DB backup
before doing anything.
Matt Parks
MVP - Microsoft CRM
----------------------------------------
----------------------------------------
On Mon, 19 Jul 2004 10:02:48 -0700, "Jouko"
<anonymous@discussions.microsoft.com> wrote:
Hello!
I have a client who installed MS CRM 1.2 standard and put
the administrator role on one of the users. Then he
rovoked the administrator role from the user (by
mistake...) and the result is that the CRM-system does
not have an administrator any more.
Is there any one that has an idea of what to do?
Thank you!
//Jouko from Sweden
