InstallAllOracleASPNETProviders 无法正常工作

发布于 2024-11-30 05:51:51 字数 1051 浏览 0 评论 0原文

我正在使用 asp.net mvc 3 和 Oracle 数据库以及 ODAC1120240Beta_EntityFramework。

我想在我的网站上进行授权。数据库工作正常，我可以使用数据库数据执行所有操作，但是如果我转到 ASP.NET 配置 -> Provider 我只看到 AspNetSqlMembershipProvider。

InstallAllOracleASPNETProviders 无法正常工作。

所有函数、视图和包均已成功创建。我所做的一切都是使用本 Oracle 指南

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

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

原文

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

分享到QQ

分享到微博