web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Customer experience | Sales, Customer Insights,...
Answered

The user can't be added to the team because the user doesn't have the "{0}" privilege.

(1) ShareShare
ReportReport
Posted on by 5

I'm trying to add a team member with no administrative access to a Microsoft dynamics 365 sales portal. When I got to sales settings and then manage users they appear in the list, but when I go to add them as a sales team for an opportunity if gives me the error message:

The user can't be added to the team because the user doesn't have the "{0}" privilege.

I'm wondering what the "{0}" privilege is and how I can add the user as a sales team. Thanks

I have the same question (0)
  • Suggested answer
    Abdul Wahab Profile Picture
    12,119 Moderator on at

    Hi davisburns,

    Is the user able to log in to the system?

    Are you a system administrator?

    Is there any option to download file?

  • davisburns Profile Picture
    5 on at

    Is the user able to log in to the system?

    They can log into other apps, but not the dynamics page. This is also an issue that I'm dealing with.

    Are you a system administrator?

    Yes, access to every administrator setting

    Is there any option to download file?

    Exception Message: The user can't be added to the team because the user doesn't have the "{0}" privilege.

    ErrorCode: -2147187902

    HexErrorCode: 0x80048342

    Error Details: {"errorCode":2147779394,"message":"The user can't be added to the team because the user doesn't have the \"{0}\" privilege.","code":2147779394,"title":"Team Error","raw":"{\"_errorCode\":2147779394,\"_errorFault\":{\"_responseXml\":null,\"_errorCode\":2147779394,\"_innerFault\":{\"_responseXml\":null,\"_errorCode\":0,\"_innerFault\":null,\"_callStack\":null,\"_responseText\":null,\"_annotations\":null,\"_messages\":[\"The user can't be added to the team because the user doesn't have the \\\"prvAppendOpportunity\\\" privilege.\"]},\"_callStack\":null,\"_responseText\":\"{\\\"error\\\":{\\\"code\\\":\\\"0x80048342\\\",\\\"message\\\":\\\"The user can't be added to the team because the user doesn't have the \\\\\\\"prvAppendOpportunity\\\\\\\" privilege.\\\",\\\"@Microsoft.PowerApps.CDS.ErrorDetails.ApiExceptionSourceKey\\\":\\\"Plugin/Microsoft.Crm.Sales.ObjectModel.Connections.ConnectionPlugin\\\",\\\"@Microsoft.PowerApps.CDS.ErrorDetails.ApiStepKey\\\":\\\"cd862d32-4564-49b5-b074-e1ab6e1f71ab\\\",\\\"@Microsoft.PowerApps.CDS.ErrorDetails.ApiDepthKey\\\":\\\"1\\\",\\\"@Microsoft.PowerApps.CDS.ErrorDetails.ApiActivityIdKey\\\":\\\"b1f9ba87-0cd3-458f-b4a3-0c5b2aa2bab3\\\",\\\"@Microsoft.PowerApps.CDS.ErrorDetails.ApiPluginSolutionNameKey\\\":\\\"System\\\",\\\"@Microsoft.PowerApps.CDS.ErrorDetails.ApiStepSolutionNameKey\\\":\\\"System\\\",\\\"@Microsoft.PowerApps.CDS.ErrorDetails.ApiExceptionCategory\\\":\\\"ClientError\\\",\\\"@Microsoft.PowerApps.CDS.ErrorDetails.ApiExceptionMessageName\\\":\\\"TargetUserInsufficientPrivileges\\\",\\\"@Microsoft.PowerApps.CDS.ErrorDetails.ApiExceptionHttpStatusCode\\\":\\\"400\\\",\\\"@Microsoft.PowerApps.CDS.ErrorDetails.0\\\":\\\"prvAppendOpportunity\\\",\\\"@Microsoft.PowerApps.CDS.HelpLink\\\":\\\"go.microsoft.com/.../ Microsoft.Crm.Sales.ObjectModel.Connections.ConnectionPlugin]\\\\r\\\\n[cd862d32-4564-49b5-b074-e1ab6e1f71ab: ConnectionPlugin]\\\\r\\\\n\\\\r\\\\n\\\",\\\"@Microsoft.PowerApps.CDS.InnerError.Message\\\":\\\"The user can't be added to the team because the user doesn't have the \\\\\\\"prvAppendOpportunity\\\\\\\" privilege.\\\"}}\",\"_annotations\":{\"@Microsoft.PowerApps.CDS.ErrorDetails.ApiExceptionSourceKey\":\"Plugin/Microsoft.Crm.Sales.ObjectModel.Connections.ConnectionPlugin\",\"@Microsoft.PowerApps.CDS.ErrorDetails.ApiStepKey\":\"cd862d32-4564-49b5-b074-e1ab6e1f71ab\",\"@Microsoft.PowerApps.CDS.ErrorDetails.ApiDepthKey\":\"1\",\"@Microsoft.PowerApps.CDS.ErrorDetails.ApiActivityIdKey\":\"b1f9ba87-0cd3-458f-b4a3-0c5b2aa2bab3\",\"@Microsoft.PowerApps.CDS.ErrorDetails.ApiPluginSolutionNameKey\":\"System\",\"@Microsoft.PowerApps.CDS.ErrorDetails.ApiStepSolutionNameKey\":\"System\",\"@Microsoft.PowerApps.CDS.ErrorDetails.ApiExceptionCategory\":\"ClientError\",\"@Microsoft.PowerApps.CDS.ErrorDetails.ApiExceptionMessageName\":\"TargetUserInsufficientPrivileges\",\"@Microsoft.PowerApps.CDS.ErrorDetails.ApiExceptionHttpStatusCode\":\"400\",\"@Microsoft.PowerApps.CDS.ErrorDetails.0\":\"prvAppendOpportunity\",\"@Microsoft.PowerApps.CDS.HelpLink\":\"go.microsoft.com/.../ Microsoft.Crm.Sales.ObjectModel.Connections.ConnectionPlugin]\\r\\n[cd862d32-4564-49b5-b074-e1ab6e1f71ab: ConnectionPlugin]\\r\\n\\r\\n\",\"@Microsoft.PowerApps.CDS.InnerError.Message\":\"The user can't be added to the team because the user doesn't have the \\\"prvAppendOpportunity\\\" privilege.\"},\"_messages\":[\"The user can't be added to the team because the user doesn't have the \\\"prvAppendOpportunity\\\" privilege.\"]},\"_message\":\"The user can't be added to the team because the user doesn't have the \\\"prvAppendOpportunity\\\" privilege.\",\"_exception\":null,\"_innerError\":null,\"_errorSource\":3,\"_blockErrorReporting\":false,\"_stack\":null,\"_faultedRequestIndex\":-1,\"_clientRequestId\":\"4e7aab13-dd76-49aa-8fd7-ba4134492ff6\",\"_serverResponseId\":\"3d98a015-03b1-46fe-87c4-9c2a7c825908, b1f9ba87-0cd3-458f-b4a3-0c5b2aa2bab3\",\"_httpStatusCode\":400,\"_retryAfter\":null,\"_date\":\"2022-12-13T18:12:30.000Z\",\"_isRequestTooLong\":false,\"message\":\"The user can't be added to the team because the user doesn't have the \\\"prvAppendOpportunity\\\" privilege.\",\"name\":\"Error\",\"stack\":\"No stack available.\",\"__action\":{\"source\":{\"actionType\":\"modernDataSource.execute.odata.async\",\"actionStack\":\"modernDataSource.execute.odata.async\",\"contextId\":\"20a71c67-5fd2-4ee1-b364-ee600348bcea\"},\"child\":{\"actionType\":\"oData.create.async\",\"actionStack\":\"oData.create.async\",\"contextId\":\"348eb6b5-e572-4263-8469-354d1e549c8d\"}}}"}

    Activity Id: c65a76c1-289b-43de-8fd8-8f91a4845c2a

  • Suggested answer
    Abdul Wahab Profile Picture
    12,119 Moderator on at

    Hi davisburns,

    As per the details of the error message

    pastedimage1670956035016v1.png

    The user needs an append privilege to the opportunity table.

  • davisburns Profile Picture
    5 on at

    How would I change this privilege?

  • Verified answer
    Abdul Wahab Profile Picture
    12,119 Moderator on at

    Hi davisburns,

    Go to the advanced settings or Solutions > Default solution > security roles. add the privilege to the role.

     pastedimage1670957892968v1.png

    For more details: learn.microsoft.com/.../database-security

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > Customer experience | Sales, Customer Insights, CRM

#1
Tom_Gioielli Profile Picture

Tom_Gioielli 81 Super User 2025 Season 2

#2
Gerardo Rentería García Profile Picture

Gerardo Rentería Ga... 49 Most Valuable Professional

#3
#ManoVerse Profile Picture

#ManoVerse 40

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans