oracle11g - ORA_ASPNET_MEM_GETALLUSERS must be declared ASP.NET MVC Oracle Providers -


as per this tutorial oracle, trying set application use oracle membership, role , state providers. while in process of setting membership, using asp.net admin tool, following error when clicking on "security" tab:

ora-06550: line 1, column 15: pls-00201: identifier 'ora_aspnet_mem_getallusers' must declared ora-06550: line 1, column 7: pl/sql: statement ignored

enter image description here

i can confirm identifier in fact exist in db.

enter image description here

i using exact same credentials membership provider rest of site , when connection sql developer.

if wondering, solution first following steps outlined here

grant privileges new database user can create schema , store web site state asp.net providers: set object type user , set user aspnet_db_user (or user of choice). 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

Comments

Post a Comment