Skip Headers
Oracle® Providers for ASP.NET Developer's Guide
11g Release 2 (11.2.0.3) for Microsoft Windows

Part Number E18737-02
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
PDF · Mobi · ePub

Oracle Providers for ASP.NET Object References

The schema in which the user runs the SQL installation script owns the tables, views, roles, stored procedures, and synonyms that the SQL script creates.

The following schema objects and their tabled information provide descriptions of what privileges each role provides, as well as the relationship between the ASP.NET service methods and the Oracle stored procedure or function.

This section lists the following objects:

Tables

Table 1-3 lists the tables that are used by each provider.

Table 1-3 Provider Tables

Oracle Provider Table

Membership

ora_aspnet_Membership

ora_aspnet_Applications

ora_aspnet_Users

Role

ora_aspnet_Roles

ora_aspnet_UsersInRoles

ora_aspnet_Applications

ora_aspnet_Users

Profile

ora_aspnet_Profile

ora_aspnet_Applications

ora_aspnet_Users

Personalization

ora_aspnet_Paths

ora_aspnet_PersonaliznAllUsers

ora_aspnet_PersonaliznPerUser

ora_aspnet_Applications

ora_aspnet_Users

Web Events

ora_aspnet_WebEvents

Site Map

ora_aspnet_SiteMap

ora_aspnet_Applications

Session State

ora_aspnet_SessionApplications

ora_aspnet_Sessions


Roles

There are, at most, three types of database roles created for each provider:

  • BasicAccess - Provides a database user with access to the provider's basic functionality.

  • ReportAccess - Provides a database user with report-oriented data gathering capabilities for a provider.

  • FullAccess - Provides a database user with access to all the database objects associated with a provider.

Table 1-4 lists the roles created for each provider.

Table 1-4 Roles and Privileges

Oracle Provider Oracle Database Role

Membership

ora_aspnet_Mem_BasicAccess

ora_aspnet_Mem_ReportAccess

ora_aspnet_Mem_FullAccess

Role

ora_aspnet_Roles_BasicAccess

ora_aspnet_Roles_ReportAccess

ora_aspnet_Roles_FullAccess

Profile

ora_aspnet_Prof_BasicAccess

ora_aspnet_Prof_ReportAccess

ora_aspnet_Prof_FullAccess

Personalization

ora_aspnet_Pers_BasicAccess

ora_aspnet_Pers_ReportAccess

ora_aspnet_Pers_FullAccess

Web Events

ora_aspnet_Wevnt_FullAccess

Site Map

ora_aspnet_Smap_FullAccess

Session

ora_aspnet_Sessn_FullAccess


Views

The following tables show the views that are created for each provider. The tables also list the provider-specific database roles that provide access to these views.

OracleMembershipProvider Views

Table 1-5 lists the roles and the view access that the roles provide.

Table 1-5 OracleMembershipProvider

Role View

ora_aspnet_Mem_BasicAccess

(none)

ora_aspnet_Mem_ReportAccess

ora_vw_aspnet_Applications

ora_vw_aspnet_Users

ora_vw_aspnet_MemUsers

ora_aspnet_Mem_FullAccess

ora_vw_aspnet_Applications

ora_vw_aspnet_Users

ora_vw_aspnet_MemUsers


OracleRoleProvider Views

Table 1-6 lists the roles and the view access that the roles provide.

Table 1-6 OracleRoleProvider

Role View

ora_aspnet_Roles_BasicAccess

(none)

ora_aspnet_Roles_ReportAccess

ora_vw_aspnet_Applications

ora_vw_aspnet_Users

ora_vw_aspnet_Roles

ora_vw_aspnet_UIR

ora_aspnet_Roles_FullAccess

ora_vw_aspnet_Applications

ora_vw_aspnet_Users

ora_vw_aspnet_Roles

ora_vw_aspnet_UIR


OracleProfileProvider Views

Table 1-7 lists the roles and the view access that the roles provide.

Table 1-7 OracleProfileProvider

Role View

ora_aspnet_Prof_BasicAccess

(none)

ora_aspnet_Prof_ReportAccess

ora_vw_aspnet_Applications

 

ora_vw_aspnet_Users

 

ora_vw_aspnet_Profiles

ora_aspnet_Prof_FullAccess

ora_vw_aspnet_Applications

 

ora_vw_aspnet_Users

 

ora_vw_aspnet_Profiles


OraclePersonalizationProvider Views

Table 1-8 lists the roles and the view access that the roles provide.

Table 1-8 OraclePersonalizationProvider

Role View

ora_aspnet_Pers_BasicAccess

(none)

ora_aspnet_Pers_ReportAccess

ora_vw_aspnet_Applications

ora_vw_aspnet_Users

ora_aspnet_Pers_FullAccess

ora_vw_aspnet_Applications

ora_vw_aspnet_Users


OracleSessionStateStore Views

Table 1-9 lists the roles and the view access that the roles provide.

Table 1-9 OracleSessionStateStore

Role View

ora_aspnet_Sessn_FullAccess

ora_vew_aspnet_sessions


Stored Procedures

The following tables list provider-specific database roles and the stored procedures for which the roles provide execution privilege. The tables also list the corresponding ASP.NET service methods that invoke the stored procedures.

OracleMembershipProvider Stored Procedures

Table 1-10 lists the service methods and stored procedures that a user with the ora_aspnet_Mem_BasicAccess role can execute.

Table 1-10 ora_aspnet_Mem_BasicAccess Role

Service Method Stored Procedure

GetNumberOfUsersOnline

ora_aspnet_Mem_GetNumOfUsersOn

GetPassword

ora_aspnet_Mem_GetPassword

GetUser

ora_aspnet_Mem_GetUserByUid

ora_aspnet_Mem_GetUserByName

GetUserNameByEmail

ora_aspnet_Mem_GetUserByEml

UpdateUser

ora_aspnet_Mem_UpdateUser

ValidateUser

ora_aspnet_Mem_GetPwdWithFmt

ora_aspnet_Mem_UpdateUserInfo


Table 1-11 lists the service methods and stored procedures that a user with the ora_aspnet_Mem_ReportAccess role can execute.

Table 1-11 ora_aspnet_Mem_ReportAccess Role

Service Method Stored Procedure

FindUsersByEmail

ora_aspnet_Mem_FindUsersByEml

FindUsersByName

ora_aspnet_Mem_FindUsersByName

GetAllUsers

ora_aspnet_Mem_GetAllUsers

GetNumberOfUsersOnline

ora_aspnet_Mem_GetNumOfUsersOn

GetUser

ora_aspnet_Mem_GetUserByUid

ora_aspnet_Mem_GetUserByName

GetUserNameByEmail

ora_aspnet_Mem_GetUserByEml


Table 1-12 lists the service methods and stored procedures that a user with the ora_aspnet_Mem_FullAccess role can execute.

Table 1-12 ora_aspnet_Mem_FullAccess Role

Service Method Stored Procedure

All Membership methods

ora_aspnet_Mem_ChangePwdQAndA

 

ora_aspnet_Mem_CreateUser

 

ora_aspnet_Mem_FindUsersByEml

 

ora_aspnet_Mem_FindUsersByName

 

ora_aspnet_Mem_GetAllUsers

 

ora_aspnet_Mem_GetNumOfUsersOn

 

ora_aspnet_Mem_GetPassword

 

ora_aspnet_Mem_GetPwdWithFmt

 

ora_aspnet_Mem_GetUserByEml

 

ora_aspnet_Mem_GetUserByName

 

ora_aspnet_Mem_GetUserByUid

 

ora_aspnet_Mem_ResetPassword

 

ora_aspnet_Mem_SetPassword

 

ora_aspnet_Mem_UnlockUser

 

ora_aspnet_Mem_UpdateUser

 

ora_aspnet_Mem_UpdateUserInfo

 

ora_aspnet_Users_DeleteUser


OracleRoleProvider Stored Procedures

Table 1-13 lists the service methods and stored procedures that a user with the ora_aspnet_Roles_BasicAccess role can execute.

Table 1-13 ora_aspnet_Roles_BasicAccess Role

Service Method Stored Procedure

GetRolesForUser

ora_aspnet_UIR_GetRolesForUser

IsUserInRole

ora_aspnet_UIR_IsUserInRole


Table 1-14 lists the service methods and stored procedures that a user with the ora_aspnet_Roles_ReportAccess role can execute.

Table 1-14 ora_aspnet_Roles_ReportAccess Role

Service Method Stored Procedure

FindUsersInRole

ora_aspnet_UIR_FindUsersInRole

GetAllRoles

ora_aspnet_Roles_GetAllRoles

GetRolesForUser

ora_aspnet_UIR_GetRolesForUser

GetUsersInRole

ora_aspnet_UIR_GetUsersInRoles

IsUserInRole

ora_aspnet_UIR_IsUserInRole

RoleExists

ora_aspnet_Roles_RoleExists


Table 1-15 lists the service methods and stored procedures that a user with the ora_aspnet_Roles_FullAccess role can execute.

Table 1-15 ora_aspnet_Roles_FullAccess Role

Service Method Stored Procedure

All Role Manager methods

ora_aspnet_Roles_CreateRole

 

ora_aspnet_Roles_DeleteRole

 

ora_aspnet_Roles_GetAllRoles

 

ora_aspnet_Roles_RoleExists

 

ora_aspnet_UIR_AddUsersToRoles

 

ora_aspnet_UIR_FindUsersInRole

 

ora_aspnet_UIR_GetRolesForUser

 

ora_aspnet_UIR_GetUsersInRoles

 

ora_aspnet_UIR_IsUserInRole

 

ora_aspnet_UIR_RemUsersFmRoles


OracleProfileProvider Stored Procedures

Table 1-16 lists the service methods and stored procedures that a user with the ora_aspnet_Prof_BasicAccess role can execute.

Table 1-16 ora_aspnet_Prof_BasicAccess Role

Service Method Stored Procedure

GetPropertyValues

ora_aspnet_Prof_GetProperties

SetPropertyValues

ora_aspnet_Prof_SetProperties


Table 1-17 lists the service methods and stored procedures that a user with the ora_aspnet_Prof_ReportAccess role can execute.

Table 1-17 ora_aspnet_Prof_ReportAccess Role

Service Method Stored Procedure

GetAllProfiles

ora_aspnet_Prof_GetProfiles

GetAllInactiveProfiles

ora_aspnet_Prof_GetProfiles

GetNumberOfInactiveProfiles

ora_aspnet_Prof_GetNumOfInactPf

FindProfilesByUserName

ora_aspnet_Prof_GetProfiles

FindInactiveProfilesByUserName

ora_aspnet_Prof_GetProfiles


Table 1-18 lists the service methods and stored procedures that a user with the ora_aspnet_Prof_FullAccess role can execute.

Table 1-18 ora_aspnet_Prof_FullAccess Role

Service Method Stored Procedure

All Profile methods

ora_aspnet_Prof_DeleteInactPf

 

ora_aspnet_Prof_DeleteProfiles

 

ora_aspnet_Prof_GetNumOfInactPf

 

ora_aspnet_Prof_GetProfiles

 

ora_aspnet_Prof_GetProperties

 

ora_aspnet_Prof_SetProperties


OraclePersonalizationProvider Stored Procedures

Table 1-19 lists the service methods and stored procedures that a user with the ora_aspnet_Pers_BasicAccess role can execute.

Table 1-19 ora_aspnet_Pers_BasicAccess Role

Service Method Stored Procedure

LoadPersonalizationState

ora_aspnet_PPU_GetPgSettings

ora_aspnet_PAU_GetPgSettings

ResetPersonalizationState

ora_aspnet_PPU_ResetPgSettings

ora_aspnet_PAU_ResetPgSettings

SavePersonalizationState

ora_aspnet_PPU_SetPgSettings

ora_aspnet_PAU_SetPgSettings


Table 1-20 lists the service methods and stored procedures that a user with the ora_aspnet_Pers_ReportAccess role can execute.

Table 1-20 ora_aspnet_Pers_ReportAccess Role

Service Method Stored Procedure

FindState

ora_aspnet_PA_FindState

GetCountOfState

ora_aspnet_PA_GetCountOfState


Table 1-21 lists the service methods and stored procedures that a user with the ora_aspnet_Pers_FullAccess role can execute.

Table 1-21 ora_aspnet_Pers_FullAccess Role

Service Method Stored Procedure

All Personalization methods

ora_aspnet_PA_FindState

 

ora_aspnet_PA_GetCountOfState

 

ora_aspnet_PA_ResetSharedState

 

ora_aspnet_PA_ResetUserState

 

ora_aspnet_PAU_GetPgSettings

 

ora_aspnet_PAU_ResetPgSettings

 

ora_aspnet_PAU_SetPgSettings

 

ora_aspnet_PPU_GetPgSettings

 

ora_aspnet_PPU_ResetPgSettings

 

ora_aspnet_PPU_SetPgSettings


OracleWebEventProvider Stored Procedures

Table 1-22 lists the service methods and stored procedures that a user with the ora_aspnet_Wevnt_FullAccess role can execute.

Table 1-22 ora_aspnet_Wevnt_FullAccess Role

Service Method Stored Procedure

All Web Event methods

ora_aspnet_LogWebEvents


OracleSiteMapProvider Stored Procedures

Table 1-23 lists the service methods and stored procedures that a user with the ora_aspnet_Smap_FullAccess role can execute.

Table 1-23 ora_aspnet_Smap_FullAccess Role

Service Method Stored Procedure

All Site Map methods

ora_aspnet_GetSiteMapData


OracleSessionStateStore Provider Stored Procedures

Table 1-24 lists the service methods and stored procedures that a user with the ora_aspnet_Sessn_FullAccess role can execute.

Table 1-24 ora_aspnet_Sessn_FullAccess Role

Service Method Stored Procedure

All Session State methods

ora_aspnet_SessnApp_SetAppID

 

ora_aspnet_Sessn_InsUninitItem

 

ora_aspnet_Sessn_RelStateItmEx

 

ora_aspnet_Sessn_RmStateItem

 

ora_aspnet_Sessn_ResetTimeout

 

ora_aspnet_Sessn_UpdStateItem

 

ora_aspnet_Sessn_InsStateItem

 

ora_aspnet_Sessn_GetStateItem

 

ora_aspnet_Sessn_GetStateItmEx


Synonyms

Public synonyms are created for all stored procedures so that they can be executed by any user in the database who is granted proper provider-specific roles by the user that owns the stored procedures.