This discussion is archived
3 Replies Latest reply: Sep 15, 2010 12:48 PM by 798077 RSS

PLS00201 ORA_ASP_MEMBERSHIP must be declared

795786 Newbie
Currently Being Moderated
I am trying to run the scripts for Oracle Membership/Role/Profile Provider on me 10g Server, and after installing the common script and sp, the compiler throws a number of the "identifier" errors listed as this post's title, PLS-00201. I am not sure why this is happening, as I am new to Oracle and need some guidance - to help assess, I will paste the compiler code I recieved as I am running the scripts through Oracle Sql Developer. I only ran the first two lines of the InstallAllOracleASPNETMembershipProviders.sql , which is @InstallOracleASPNETCommon.sql(plb executed from within) and @InstallOracleASPNETMembership.sql (the error looks llike it is being thrown on the execution of the Membership SP file (which is wrapped, so I do not know what is going on with the query) - Is this a bug, or just a newbie mistake ? Compiler output below :


USER
------------------------------
TJ

old:DECLARE n NUMBER;
BEGIN
SELECT count(*) INTO n FROM tab WHERE tname='ORA_ASPNET_APPLICATIONS';
IF n <= 0 THEN
EXECUTE IMMEDIATE
'CREATE TABLE ora_aspnet_Membership
(
ApplicationId RAW (16) NOT NULL,
UserId RAW (16) NOT NULL PRIMARY KEY,
Password NVARCHAR2 (128) NOT NULL,
PasswordFormat INTEGER DEFAULT 0 NOT NULL,
PasswordSalt NVARCHAR2 (128) NOT NULL,
MobilePIN NVARCHAR2 (16),
Email NVARCHAR2 (256),
LoweredEmail NVARCHAR2 (256),
PasswordQuestion NVARCHAR2 (256),
PasswordAnswer NVARCHAR2 (128),
IsApproved INTEGER NOT NULL,
IsLockedOut INTEGER NOT NULL,
CreateDate DATE NOT NULL,
LastLoginDate DATE NOT NULL,
LastPasswordChangedDate     DATE NOT NULL,
LastLockoutDate DATE NOT NULL,
FailedPwdAttemptCount INTEGER NOT NULL,
FailedPwdAttemptWinStart DATE NOT NULL,
FailedPwdAnswerAttemptCount INTEGER NOT NULL,
FailedPwdAnswerAttemptWinStart DATE NOT NULL,
Comments NCLOB
)';

-- Add constraints for data integrity
EXECUTE IMMEDIATE 'ALTER TABLE ora_aspnet_Membership ADD CONSTRAINT fk_membership_Appid FOREIGN KEY (ApplicationId)
REFERENCES ora_aspnet_Applications(ApplicationId)';

EXECUTE IMMEDIATE 'ALTER TABLE ora_aspnet_Membership ADD CONSTRAINT fk_membership_userid FOREIGN KEY (UserId)
REFERENCES ora_aspnet_Users (UserId)';


-- Create read-only view
EXECUTE IMMEDIATE 'CREATE OR REPLACE VIEW ora_vw_aspnet_MemUsers AS
SELECT m.UserId,
m.PasswordFormat,
m.MobilePIN,
m.Email,
m.LoweredEmail,
m.PasswordQuestion,
m.PasswordAnswer,
m.IsApproved,
m.IsLockedOut,
m.CreateDate,
m.LastLoginDate,
m.LastPasswordChangedDate,
m.LastLockoutDate,
m.FailedPwdAttemptCount,
m.FailedPwdAttemptWinStart,
m.FailedPwdAnswerAttemptCount,
m.FailedPwdAnswerAttemptWinStart,
m.Comments,
u.ApplicationId,
u.UserName,
u.MobileAlias,
u.IsAnonymous,
u.LastActivityDate
FROM ora_aspnet_Membership m, ora_aspnet_Users u
WHERE m.UserId = u.UserId
WITH READ ONLY';

-- Create roles. create role privilege is required.
EXECUTE IMMEDIATE 'CREATE ROLE ora_aspnet_Mem_BasicAccess';
EXECUTE IMMEDIATE 'CREATE ROLE ora_aspnet_Mem_ReportAccess';
EXECUTE IMMEDIATE 'CREATE ROLE ora_aspnet_Mem_FullAccess';


-- Create public synonym. Create public synonym privilege is required.
execute immediate 'CREATE PUBLIC SYNONYM ora_aspnet_Users_DeleteUser FOR &CurrentUser..ora_aspnet_Users_DeleteUser';
execute immediate 'CREATE PUBLIC SYNONYM ora_aspnet_Mem_DeleteUser FOR &CurrentUser..ora_aspnet_Mem_DeleteUser';
execute immediate 'CREATE PUBLIC SYNONYM ora_aspnet_Mem_GetUserByUid FOR &CurrentUser..ora_aspnet_Mem_GetUserByUid';
execute immediate 'CREATE PUBLIC SYNONYM ora_aspnet_Mem_GetUserByName FOR &CurrentUser..ora_aspnet_Mem_GetUserByName';
execute immediate 'CREATE PUBLIC SYNONYM ora_aspnet_Mem_GetUserByEml FOR &CurrentUser..ora_aspnet_Mem_GetUserByEml';
execute immediate 'CREATE PUBLIC SYNONYM ora_aspnet_Mem_GetPassword FOR &CurrentUser..ora_aspnet_Mem_GetPassword';
execute immediate 'CREATE PUBLIC SYNONYM ora_aspnet_Mem_GetPwdWithFmt FOR &CurrentUser..ora_aspnet_Mem_GetPwdWithFmt';
execute immediate 'CREATE PUBLIC SYNONYM ora_aspnet_Mem_UpdateUserInfo FOR &CurrentUser..ora_aspnet_Mem_UpdateUserInfo';
execute immediate 'CREATE PUBLIC SYNONYM ora_aspnet_Mem_GetNumOfUsersOn FOR &CurrentUser..ora_aspnet_Mem_GetNumOfUsersOn';
execute immediate 'CREATE PUBLIC SYNONYM ora_aspnet_Mem_GetAllUsers FOR &CurrentUser..ora_aspnet_Mem_GetAllUsers';
execute immediate 'CREATE PUBLIC SYNONYM ora_aspnet_Mem_FindUsersByName FOR &CurrentUser..ora_aspnet_Mem_FindUsersByName';
execute immediate 'CREATE PUBLIC SYNONYM ora_aspnet_Mem_FindUsersByEml FOR &CurrentUser..ora_aspnet_Mem_FindUsersByEml';
execute immediate 'CREATE PUBLIC SYNONYM ora_aspnet_Mem_CreateUser FOR &CurrentUser..ora_aspnet_Mem_CreateUser';
execute immediate 'CREATE PUBLIC SYNONYM ora_aspnet_Mem_SetPassword FOR &CurrentUser..ora_aspnet_Mem_SetPassword';
execute immediate 'CREATE PUBLIC SYNONYM ora_aspnet_Mem_ResetPassword FOR &CurrentUser..ora_aspnet_Mem_ResetPassword';
execute immediate 'CREATE PUBLIC SYNONYM ora_aspnet_Mem_UpdateUser FOR &CurrentUser..ora_aspnet_Mem_UpdateUser';
execute immediate 'CREATE PUBLIC SYNONYM ora_aspnet_Mem_ChangePwdQAndA FOR &CurrentUser..ora_aspnet_Mem_ChangePwdQAndA';
execute immediate 'CREATE PUBLIC SYNONYM ora_aspnet_Mem_UnlockUser FOR &CurrentUser..ora_aspnet_Mem_UnlockUser';

END IF;
END;
new:DECLARE n NUMBER;
BEGIN
SELECT count(*) INTO n FROM tab WHERE tname='ORA_ASPNET_APPLICATIONS';
IF n <= 0 THEN
EXECUTE IMMEDIATE
'CREATE TABLE ora_aspnet_Membership
(
ApplicationId RAW (16) NOT NULL,
UserId RAW (16) NOT NULL PRIMARY KEY,
Password NVARCHAR2 (128) NOT NULL,
PasswordFormat INTEGER DEFAULT 0 NOT NULL,
PasswordSalt NVARCHAR2 (128) NOT NULL,
MobilePIN NVARCHAR2 (16),
Email NVARCHAR2 (256),
LoweredEmail NVARCHAR2 (256),
PasswordQuestion NVARCHAR2 (256),
PasswordAnswer NVARCHAR2 (128),
IsApproved INTEGER NOT NULL,
IsLockedOut INTEGER NOT NULL,
CreateDate DATE NOT NULL,
LastLoginDate DATE NOT NULL,
LastPasswordChangedDate     DATE NOT NULL,
LastLockoutDate DATE NOT NULL,
FailedPwdAttemptCount INTEGER NOT NULL,
FailedPwdAttemptWinStart DATE NOT NULL,
FailedPwdAnswerAttemptCount INTEGER NOT NULL,
FailedPwdAnswerAttemptWinStart DATE NOT NULL,
Comments NCLOB
)';

-- Add constraints for data integrity
EXECUTE IMMEDIATE 'ALTER TABLE ora_aspnet_Membership ADD CONSTRAINT fk_membership_Appid FOREIGN KEY (ApplicationId)
REFERENCES ora_aspnet_Applications(ApplicationId)';

EXECUTE IMMEDIATE 'ALTER TABLE ora_aspnet_Membership ADD CONSTRAINT fk_membership_userid FOREIGN KEY (UserId)
REFERENCES ora_aspnet_Users (UserId)';

-- Create read-only view
EXECUTE IMMEDIATE 'CREATE OR REPLACE VIEW ora_vw_aspnet_MemUsers AS
SELECT m.UserId,
m.PasswordFormat,
m.MobilePIN,
m.Email,
m.LoweredEmail,
m.PasswordQuestion,
m.PasswordAnswer,
m.IsApproved,
m.IsLockedOut,
m.CreateDate,
m.LastLoginDate,
m.LastPasswordChangedDate,
m.LastLockoutDate,
m.FailedPwdAttemptCount,
m.FailedPwdAttemptWinStart,
m.FailedPwdAnswerAttemptCount,
m.FailedPwdAnswerAttemptWinStart,
m.Comments,
u.ApplicationId,
u.UserName,
u.MobileAlias,
u.IsAnonymous,
u.LastActivityDate
FROM ora_aspnet_Membership m, ora_aspnet_Users u
WHERE m.UserId = u.UserId
WITH READ ONLY';

-- Create roles. create role privilege is required.
EXECUTE IMMEDIATE 'CREATE ROLE ora_aspnet_Mem_BasicAccess';
EXECUTE IMMEDIATE 'CREATE ROLE ora_aspnet_Mem_ReportAccess';
EXECUTE IMMEDIATE 'CREATE ROLE ora_aspnet_Mem_FullAccess';


-- Create public synonym. Create public synonym privilege is required.
execute immediate 'CREATE PUBLIC SYNONYM ora_aspnet_Users_DeleteUser FOR TJ.ora_aspnet_Users_DeleteUser';
execute immediate 'CREATE PUBLIC SYNONYM ora_aspnet_Mem_DeleteUser FOR TJ.ora_aspnet_Mem_DeleteUser';
execute immediate 'CREATE PUBLIC SYNONYM ora_aspnet_Mem_GetUserByUid FOR TJ.ora_aspnet_Mem_GetUserByUid';
execute immediate 'CREATE PUBLIC SYNONYM ora_aspnet_Mem_GetUserByName FOR TJ.ora_aspnet_Mem_GetUserByName';
execute immediate 'CREATE PUBLIC SYNONYM ora_aspnet_Mem_GetUserByEml FOR TJ.ora_aspnet_Mem_GetUserByEml';
execute immediate 'CREATE PUBLIC SYNONYM ora_aspnet_Mem_GetPassword FOR TJ.ora_aspnet_Mem_GetPassword';
execute immediate 'CREATE PUBLIC SYNONYM ora_aspnet_Mem_GetPwdWithFmt FOR TJ.ora_aspnet_Mem_GetPwdWithFmt';
execute immediate 'CREATE PUBLIC SYNONYM ora_aspnet_Mem_UpdateUserInfo FOR TJ.ora_aspnet_Mem_UpdateUserInfo';
execute immediate 'CREATE PUBLIC SYNONYM ora_aspnet_Mem_GetNumOfUsersOn FOR TJ.ora_aspnet_Mem_GetNumOfUsersOn';
execute immediate 'CREATE PUBLIC SYNONYM ora_aspnet_Mem_GetAllUsers FOR TJ.ora_aspnet_Mem_GetAllUsers';
execute immediate 'CREATE PUBLIC SYNONYM ora_aspnet_Mem_FindUsersByName FOR TJ.ora_aspnet_Mem_FindUsersByName';
execute immediate 'CREATE PUBLIC SYNONYM ora_aspnet_Mem_FindUsersByEml FOR TJ.ora_aspnet_Mem_FindUsersByEml';
execute immediate 'CREATE PUBLIC SYNONYM ora_aspnet_Mem_CreateUser FOR TJ.ora_aspnet_Mem_CreateUser';
execute immediate 'CREATE PUBLIC SYNONYM ora_aspnet_Mem_SetPassword FOR TJ.ora_aspnet_Mem_SetPassword';
execute immediate 'CREATE PUBLIC SYNONYM ora_aspnet_Mem_ResetPassword FOR TJ.ora_aspnet_Mem_ResetPassword';
execute immediate 'CREATE PUBLIC SYNONYM ora_aspnet_Mem_UpdateUser FOR TJ.ora_aspnet_Mem_UpdateUser';
execute immediate 'CREATE PUBLIC SYNONYM ora_aspnet_Mem_ChangePwdQAndA FOR TJ.ora_aspnet_Mem_ChangePwdQAndA';
execute immediate 'CREATE PUBLIC SYNONYM ora_aspnet_Mem_UnlockUser FOR TJ.ora_aspnet_Mem_UnlockUser';

END IF;
END;
anonymous block completed
FUNCTION ORA_ASPNET_MEM_CHANGEPWDQANDA compiled
Correction: Warning: FUNCTION ORA_ASPNET_MEM_CHANGEPWDQANDA created with compilation warnings or errors.
Errors: check compiler log
FUNCTION ORA_ASPNET_MEM_CREATEUSER compiled
Correction: Warning: FUNCTION ORA_ASPNET_MEM_CREATEUSER created with compilation warnings or errors.
Errors: check compiler log
FUNCTION ORA_ASPNET_MEM_FINDUSERSBYNAME compiled
Correction: Warning: FUNCTION ORA_ASPNET_MEM_FINDUSERSBYNAME created with compilation warnings or errors.
Errors: check compiler log
FUNCTION ORA_ASPNET_MEM_FINDUSERSBYEML compiled
Correction: Warning: FUNCTION ORA_ASPNET_MEM_FINDUSERSBYEML created with compilation warnings or errors.
Errors: check compiler log
FUNCTION ORA_ASPNET_MEM_GETPWDWITHFMT compiled
Correction: Warning: FUNCTION ORA_ASPNET_MEM_GETPWDWITHFMT created with compilation warnings or errors.
Errors: check compiler log
FUNCTION ORA_ASPNET_MEM_GETPASSWORD compiled
Correction: Warning: FUNCTION ORA_ASPNET_MEM_GETPASSWORD created with compilation warnings or errors.
Errors: check compiler log
FUNCTION ORA_ASPNET_MEM_SETPASSWORD compiled
Correction: Warning: FUNCTION ORA_ASPNET_MEM_SETPASSWORD created with compilation warnings or errors.
Errors: check compiler log
FUNCTION ORA_ASPNET_MEM_GETUSERBYUID compiled
Correction: Warning: FUNCTION ORA_ASPNET_MEM_GETUSERBYUID created with compilation warnings or errors.
Errors: check compiler log
FUNCTION ORA_ASPNET_MEM_GETUSERBYNAME compiled
Correction: Warning: FUNCTION ORA_ASPNET_MEM_GETUSERBYNAME created with compilation warnings or errors.
Errors: check compiler log
FUNCTION ORA_ASPNET_MEM_GETUSERBYEML compiled
Correction: Warning: FUNCTION ORA_ASPNET_MEM_GETUSERBYEML created with compilation warnings or errors.
Errors: check compiler log
FUNCTION ORA_ASPNET_MEM_GETALLUSERS compiled
Correction: Warning: FUNCTION ORA_ASPNET_MEM_GETALLUSERS created with compilation warnings or errors.
Errors: check compiler log
FUNCTION ORA_ASPNET_MEM_GETNUMOFUSERSON compiled
Correction: Warning: FUNCTION ORA_ASPNET_MEM_GETNUMOFUSERSON created with compilation warnings or errors.
Errors: check compiler log
FUNCTION ORA_ASPNET_MEM_RESETPASSWORD compiled
Correction: Warning: FUNCTION ORA_ASPNET_MEM_RESETPASSWORD created with compilation warnings or errors.
Errors: check compiler log
FUNCTION ORA_ASPNET_MEM_UPDATEUSER compiled
Correction: Warning: FUNCTION ORA_ASPNET_MEM_UPDATEUSER created with compilation warnings or errors.
Errors: check compiler log
FUNCTION ORA_ASPNET_MEM_UNLOCKUSER compiled
Correction: Warning: FUNCTION ORA_ASPNET_MEM_UNLOCKUSER created with compilation warnings or errors.
Errors: check compiler log
FUNCTION ORA_ASPNET_MEM_UPDATEUSERINFO compiled
Correction: Warning: FUNCTION ORA_ASPNET_MEM_UPDATEUSERINFO created with compilation warnings or errors.
Errors: check compiler log
FUNCTION ORA_ASPNET_MEM_DELETEUSER compiled
Correction: Warning: FUNCTION ORA_ASPNET_MEM_DELETEUSER created with compilation warnings or errors.
Errors: check compiler log

Error starting at line 129 in command:
GRANT SELECT ON ora_vw_aspnet_Applications TO ora_aspnet_Mem_ReportAccess
Error report:
SQL Error: ORA-01917: user or role 'ORA_ASPNET_MEM_REPORTACCESS' does not exist
01917. 00000 - "user or role '%s' does not exist"
*Cause:    There is not a user or role by that name.
*Action:   Re-specify the name.

Error starting at line 130 in command:
GRANT SELECT ON ora_vw_aspnet_Users TO ora_aspnet_Mem_ReportAccess
Error report:
SQL Error: ORA-01917: user or role 'ORA_ASPNET_MEM_REPORTACCESS' does not exist
01917. 00000 - "user or role '%s' does not exist"
*Cause:    There is not a user or role by that name.
*Action:   Re-specify the name.

Error starting at line 131 in command:
GRANT SELECT ON ora_vw_aspnet_MemUsers TO ora_aspnet_Mem_ReportAccess
Error report:
SQL Error: ORA-00942: table or view does not exist
00942. 00000 - "table or view does not exist"
*Cause:   
*Action:

Error starting at line 135 in command:
GRANT ora_aspnet_Mem_BasicAccess TO ora_aspnet_Mem_FullAccess
Error report:
SQL Error: ORA-01917: user or role 'ORA_ASPNET_MEM_FULLACCESS' does not exist
01917. 00000 - "user or role '%s' does not exist"
*Cause:    There is not a user or role by that name.
*Action:   Re-specify the name.

Error starting at line 136 in command:
GRANT ora_aspnet_Mem_ReportAccess TO ora_aspnet_Mem_FullAccess
Error report:
SQL Error: ORA-01917: user or role 'ORA_ASPNET_MEM_FULLACCESS' does not exist
01917. 00000 - "user or role '%s' does not exist"
*Cause:    There is not a user or role by that name.
*Action:   Re-specify the name.

Error starting at line 139 in command:
GRANT EXECUTE ON ora_aspnet_Mem_GetUserByUid TO ora_aspnet_Mem_BasicAccess
Error report:
SQL Error: ORA-01917: user or role 'ORA_ASPNET_MEM_BASICACCESS' does not exist
01917. 00000 - "user or role '%s' does not exist"
*Cause:    There is not a user or role by that name.
*Action:   Re-specify the name.

Error starting at line 140 in command:
GRANT EXECUTE ON ora_aspnet_Mem_GetUserByName TO ora_aspnet_Mem_BasicAccess
Error report:
SQL Error: ORA-01917: user or role 'ORA_ASPNET_MEM_BASICACCESS' does not exist
01917. 00000 - "user or role '%s' does not exist"
*Cause:    There is not a user or role by that name.
*Action:   Re-specify the name.

Error starting at line 141 in command:
GRANT EXECUTE ON ora_aspnet_Mem_GetUserByEml TO ora_aspnet_Mem_BasicAccess
Error report:
SQL Error: ORA-01917: user or role 'ORA_ASPNET_MEM_BASICACCESS' does not exist
01917. 00000 - "user or role '%s' does not exist"
*Cause:    There is not a user or role by that name.
*Action:   Re-specify the name.

Error starting at line 142 in command:
GRANT EXECUTE ON ora_aspnet_Mem_GetPassword TO ora_aspnet_Mem_BasicAccess
Error report:
SQL Error: ORA-01917: user or role 'ORA_ASPNET_MEM_BASICACCESS' does not exist
01917. 00000 - "user or role '%s' does not exist"
*Cause:    There is not a user or role by that name.
*Action:   Re-specify the name.

Error starting at line 143 in command:
GRANT EXECUTE ON ora_aspnet_Mem_GetPwdWithFmt TO ora_aspnet_Mem_BasicAccess
Error report:
SQL Error: ORA-01917: user or role 'ORA_ASPNET_MEM_BASICACCESS' does not exist
01917. 00000 - "user or role '%s' does not exist"
*Cause:    There is not a user or role by that name.
*Action:   Re-specify the name.

Error starting at line 144 in command:
GRANT EXECUTE ON ora_aspnet_Mem_GetNumOfUsersOn TO ora_aspnet_Mem_BasicAccess
Error report:
SQL Error: ORA-01917: user or role 'ORA_ASPNET_MEM_BASICACCESS' does not exist
01917. 00000 - "user or role '%s' does not exist"
*Cause:    There is not a user or role by that name.
*Action:   Re-specify the name.

Error starting at line 145 in command:
GRANT EXECUTE ON ora_aspnet_Mem_UpdateUserInfo TO ora_aspnet_Mem_BasicAccess
Error report:
SQL Error: ORA-01917: user or role 'ORA_ASPNET_MEM_BASICACCESS' does not exist
01917. 00000 - "user or role '%s' does not exist"
*Cause:    There is not a user or role by that name.
*Action:   Re-specify the name.

Error starting at line 148 in command:
GRANT EXECUTE ON ora_aspnet_Mem_GetUserByUid TO ora_aspnet_Mem_ReportAccess
Error report:
SQL Error: ORA-01917: user or role 'ORA_ASPNET_MEM_REPORTACCESS' does not exist
01917. 00000 - "user or role '%s' does not exist"
*Cause:    There is not a user or role by that name.
*Action:   Re-specify the name.

Error starting at line 149 in command:
GRANT EXECUTE ON ora_aspnet_Mem_GetUserByName TO ora_aspnet_Mem_ReportAccess
Error report:
SQL Error: ORA-01917: user or role 'ORA_ASPNET_MEM_REPORTACCESS' does not exist
01917. 00000 - "user or role '%s' does not exist"
*Cause:    There is not a user or role by that name.
*Action:   Re-specify the name.

Error starting at line 150 in command:
GRANT EXECUTE ON ora_aspnet_Mem_GetUserByEml TO ora_aspnet_Mem_ReportAccess
Error report:
SQL Error: ORA-01917: user or role 'ORA_ASPNET_MEM_REPORTACCESS' does not exist
01917. 00000 - "user or role '%s' does not exist"
*Cause:    There is not a user or role by that name.
*Action:   Re-specify the name.

Error starting at line 151 in command:
GRANT EXECUTE ON ora_aspnet_Mem_GetAllUsers TO ora_aspnet_Mem_ReportAccess
Error report:
SQL Error: ORA-01917: user or role 'ORA_ASPNET_MEM_REPORTACCESS' does not exist
01917. 00000 - "user or role '%s' does not exist"
*Cause:    There is not a user or role by that name.
*Action:   Re-specify the name.

Error starting at line 152 in command:
GRANT EXECUTE ON ora_aspnet_Mem_GetNumOfUsersOn TO ora_aspnet_Mem_ReportAccess
Error report:
SQL Error: ORA-01917: user or role 'ORA_ASPNET_MEM_REPORTACCESS' does not exist
01917. 00000 - "user or role '%s' does not exist"
*Cause:    There is not a user or role by that name.
*Action:   Re-specify the name.

Error starting at line 153 in command:
GRANT EXECUTE ON ora_aspnet_Mem_FindUsersByName TO ora_aspnet_Mem_ReportAccess
Error report:
SQL Error: ORA-01917: user or role 'ORA_ASPNET_MEM_REPORTACCESS' does not exist
01917. 00000 - "user or role '%s' does not exist"
*Cause:    There is not a user or role by that name.
*Action:   Re-specify the name.

Error starting at line 154 in command:
GRANT EXECUTE ON ora_aspnet_Mem_FindUsersByEml TO ora_aspnet_Mem_ReportAccess
Error report:
SQL Error: ORA-01917: user or role 'ORA_ASPNET_MEM_REPORTACCESS' does not exist
01917. 00000 - "user or role '%s' does not exist"
*Cause:    There is not a user or role by that name.
*Action:   Re-specify the name.

Error starting at line 157 in command:
GRANT EXECUTE ON ora_aspnet_Users_DeleteUser TO ora_aspnet_Mem_FullAccess
Error report:
SQL Error: ORA-01917: user or role 'ORA_ASPNET_MEM_FULLACCESS' does not exist
01917. 00000 - "user or role '%s' does not exist"
*Cause:    There is not a user or role by that name.
*Action:   Re-specify the name.

Error starting at line 158 in command:
GRANT EXECUTE ON ora_aspnet_Mem_DeleteUser TO ora_aspnet_Mem_FullAccess
Error report:
SQL Error: ORA-01917: user or role 'ORA_ASPNET_MEM_FULLACCESS' does not exist
01917. 00000 - "user or role '%s' does not exist"
*Cause:    There is not a user or role by that name.
*Action:   Re-specify the name.

Error starting at line 159 in command:
GRANT EXECUTE ON ora_aspnet_Mem_CreateUser TO ora_aspnet_Mem_FullAccess
Error report:
SQL Error: ORA-01917: user or role 'ORA_ASPNET_MEM_FULLACCESS' does not exist
01917. 00000 - "user or role '%s' does not exist"
*Cause:    There is not a user or role by that name.
*Action:   Re-specify the name.

Error starting at line 160 in command:
GRANT EXECUTE ON ora_aspnet_Mem_SetPassword TO ora_aspnet_Mem_FullAccess
Error report:
SQL Error: ORA-01917: user or role 'ORA_ASPNET_MEM_FULLACCESS' does not exist
01917. 00000 - "user or role '%s' does not exist"
*Cause:    There is not a user or role by that name.
*Action:   Re-specify the name.

Error starting at line 161 in command:
GRANT EXECUTE ON ora_aspnet_Mem_ResetPassword TO ora_aspnet_Mem_FullAccess
Error report:
SQL Error: ORA-01917: user or role 'ORA_ASPNET_MEM_FULLACCESS' does not exist
01917. 00000 - "user or role '%s' does not exist"
*Cause:    There is not a user or role by that name.
*Action:   Re-specify the name.

Error starting at line 162 in command:
GRANT EXECUTE ON ora_aspnet_Mem_UpdateUser TO ora_aspnet_Mem_FullAccess
Error report:
SQL Error: ORA-01917: user or role 'ORA_ASPNET_MEM_FULLACCESS' does not exist
01917. 00000 - "user or role '%s' does not exist"
*Cause:    There is not a user or role by that name.
*Action:   Re-specify the name.

Error starting at line 163 in command:
GRANT EXECUTE ON ora_aspnet_Mem_ChangePwdQAndA TO ora_aspnet_Mem_FullAccess
Error report:
SQL Error: ORA-01917: user or role 'ORA_ASPNET_MEM_FULLACCESS' does not exist
01917. 00000 - "user or role '%s' does not exist"
*Cause:    There is not a user or role by that name.
*Action:   Re-specify the name.

Error starting at line 164 in command:
GRANT EXECUTE ON ora_aspnet_Mem_UnlockUser TO ora_aspnet_Mem_FullAccess
Error report:
SQL Error: ORA-01917: user or role 'ORA_ASPNET_MEM_FULLACCESS' does not exist
01917. 00000 - "user or role '%s' does not exist"
*Cause:    There is not a user or role by that name.
*Action:   Re-specify the name.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points