Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

oracle 管理员管理---权限设置,然后分配角色,报错。 #903

jiangbin4586 opened this issue Jun 20, 2018 · 2 comments


Copy link

@jiangbin4586 jiangbin4586 commented Jun 20, 2018

oracle 管理员管理---权限设置,然后分配角色,报错。。以下代码是在页面源代码里面拷贝出来的。

错误!   用户角色分配失败<!-- Oracle.ManagedDataAccess.Client.OracleException (0x80004005): ORA-00001: 违反唯一约束条件 (CMS.PK_SITESERVER_ADMINISTRATORSINROLES_ID)

  | 在 OracleInternal.ServiceObjects.OracleConnectionImpl.VerifyExecution(Int32& cursorId, Boolean bThrowArrayBindRelatedErrors, SqlStatementType sqlStatementType, Int32 arrayBindCount, OracleException& exceptionForArrayBindDML, Boolean& hasMoreRowsInDB, Boolean bFirstIterationDone)
  | 在 OracleInternal.ServiceObjects.OracleCommandImpl.ExecuteNonQuery(String commandText, OracleParameterCollection paramColl, CommandType commandType, OracleConnectionImpl connectionImpl, Int32 longFetchSize, Int64 clientInitialLOBFS, OracleDependencyImpl orclDependencyImpl, Int64[]& scnFromExecution, OracleParameterCollection& bindByPositionParamColl, Boolean& bBindParamPresent, OracleException& exceptionForArrayBindDML, OracleConnection connection, OracleLogicalTransaction& oracleLogicalTransaction, Boolean isFromEF)
  | 在 Oracle.ManagedDataAccess.Client.OracleCommand.ExecuteNonQuery()
  | 在 SiteServer.CMS.Data.DbHelper.ExecuteNonQuery(IDbCommand command)
  | 在 SiteServer.CMS.Data.DbHelper.ExecuteNonQuery(IDbConnection connection, String commandText, IDataParameter[] commandParameters)
  | 在 SiteServer.CMS.Data.DbHelper.ExecuteNonQuery(String connectionString, String commandText, IDataParameter[] commandParameters)
  | 在 SiteServer.CMS.Provider.AdministratorsInRolesDao.AddUserToRole(String userName, String roleName)
  | 在 SiteServer.CMS.Provider.AdministratorsInRolesDao.AddUserToRoles(String userName, String[] roleNames)
  | 在 SiteServer.BackgroundPages.Settings.ModalPermissionsSet.AddRole_OnClick(Object sender, EventArgs e) -->

@starlying starlying added the BUG label Jun 22, 2018

This comment has been minimized.

Copy link

@starlying starlying commented Jun 22, 2018


@starlying starlying mentioned this issue Jun 22, 2018
37 of 37 tasks complete
@starlying starlying mentioned this issue Jul 1, 2018
43 of 43 tasks complete
@starlying starlying mentioned this issue Aug 1, 2018
30 of 30 tasks complete

This comment has been minimized.

Copy link

@starlying starlying commented Aug 21, 2018


@starlying starlying closed this Aug 21, 2018
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
None yet
2 participants
You can’t perform that action at this time.