InstallAllOracleASPNETProviders不能正常工作 [英] InstallAllOracleASPNETProviders doesn't work correctly

问题描述

我使用asp.net MVC 3和Oracle数据库ODAC1120240Beta_EntityFramework。

我想要做的授权在我的网站。数据库正常工作，我所能做的一切与数据库中的数据，但如果我去 ASP.NET配置 - ＆GT;供应商我只看到 AspNetSqlMembershipProvider 。

InstallAllOracleASPNETProviders无法正常工作。

所有的功能，视图和包被succesully创建。我做的所有使用此Oracle指南

下面是Oracle数据库输出的一部分从Visual Studio工具执行此脚本后。

  GRANT SELECT ON ora_vw_aspnet_Applications TO ora_aspnet_Mem_ReportAccess
                                              *
错误串1：
ORA-01917：用户或角色'ORA_ASPNET_MEM_REPORTACCESS'不存在
GRANT SELECT ON ora_vw_aspnet_Users TO ora_aspnet_Mem_ReportAccess
                                       *
错误串1：
ORA-01917：用户或角色'ORA_ASPNET_MEM_REPORTACCESS'不存在
GRANT SELECT ON ora_vw_aspnet_MemUsers TO ora_aspnet_Mem_ReportAccess
                *
错误串1：
ORA-00942：表或视图不存在
 

解决方案

可以实现使用<一个href=\"http://quysnhat.word$p$pss.com/2011/09/13/using-membership-with-oracle-database-in-asp-net-mvc-3/\"相对=nofollow>流程链接。

I am using asp.net mvc 3 and oracle database with ODAC1120240Beta_EntityFramework.

I want to do authorization in my site. Database works correctly, I can do everything with Database data, but if I go to ASP.NET Configuration -> Provider I see only AspNetSqlMembershipProvider.

InstallAllOracleASPNETProviders doesn't work correctly.

All functions, views and packages were created succesully. I do all using this Oracle Guide

Here is part of Oracle Database Output after executing this script from Visual Studio Tools.

GRANT SELECT ON ora_vw_aspnet_Applications TO ora_aspnet_Mem_ReportAccess
                                              *
error in string 1:
ORA-01917: user or role 'ORA_ASPNET_MEM_REPORTACCESS' does not exist


GRANT SELECT ON ora_vw_aspnet_Users TO ora_aspnet_Mem_ReportAccess
                                       *
error in string 1:
ORA-01917: user or role 'ORA_ASPNET_MEM_REPORTACCESS' does not exist


GRANT SELECT ON ora_vw_aspnet_MemUsers TO ora_aspnet_Mem_ReportAccess
                *
error in string 1:
ORA-00942: table or view does not exist

解决方案

You can implement using flow link.

这篇关于InstallAllOracleASPNETProviders不能正常工作的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！