必须将ORA_ASPNET_MEM_GETALLUSERS声明为ASP.NET MVC Oracle提供程序 [英] ORA_ASPNET_MEM_GETALLUSERS must be declared ASP.NET MVC Oracle Providers

问题描述

按照

授予新数据库用户特权，以便它可以为ASP.NET提供程序创建架构并存储网站状态:将对象类型"设置为"USER"，并将用户"设置为ASPNET_DB_USER(或您选择的用户).通常需要的特权包括:

1. 更改通知
2. 创建工作
3. 创建过程
4. 创建公共同义词
5. 创建角色
6. 创建会话
7. 创建表格
8. 创建视图
9. 删除公共同义词
10. 无限表空间

As per this tutorial from Oracle, I am trying to set up my application to use the Oracle Membership, Role and state providers. While in the process of setting up the membership, using the ASP.NET Admin tool, I get the following error when clicking on the "Security" tab:

ORA-06550: line 1, column 15: PLS-00201: identifier 'ORA_ASPNET_MEM_GETALLUSERS' must be declared ORA-06550: line 1, column 7: PL/SQL: Statement ignored

I can confirm that the identifier DOES in fact exist in the DB.

I am using the exact same credentials for the membership provider as I do for the rest of the site and also when connection to SQL Developer.

解决方案

If anyone was wondering, the solution was to first do the following steps outlined here

Grant privileges to the new database user so it can create the schema and store web site state for the ASP.NET providers: Set Object type to USER and set User to ASPNET_DB_USER (or your user of choice). The generally required privileges include:

1. Change notification
2. Create job
3. Create procedure
4. Create public synonym
5. Create role
6. Create session
7. Create table
8. Create view
9. Drop public synonym
10. Unlimited Tablespace

这篇关于必须将ORA_ASPNET_MEM_GETALLUSERS声明为ASP.NET MVC Oracle提供程序的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！