Edit D:\app\Administrator\product\11.2.0\dbhome_1\ASP.NET\SQL\UninstallOracleRoles.sql
-- Copyright (c) 2002, 2007, Oracle. All rights reserved. -- Drop public synonyms. Drop public synonym privilege is required. DROP PUBLIC SYNONYM ora_aspnet_Roles_CreateRole; DROP PUBLIC SYNONYM ora_aspnet_Roles_DeleteRole; DROP PUBLIC SYNONYM ora_aspnet_Roles_GetAllRoles; DROP PUBLIC SYNONYM ora_aspnet_Roles_RoleExists; DROP PUBLIC SYNONYM ora_aspnet_UIR_AddUsersToRoles; DROP PUBLIC SYNONYM ora_aspnet_UIR_FindUsersInRole; DROP PUBLIC SYNONYM ora_aspnet_UIR_GetRolesForUser; DROP PUBLIC SYNONYM ora_aspnet_UIR_GetUsersInRoles; DROP PUBLIC SYNONYM ora_aspnet_UIR_IsUserInRole; DROP PUBLIC SYNONYM ora_aspnet_UIR_RemUsersFmRoles; -- Drop roles DROP ROLE ora_aspnet_Roles_BasicAccess; DROP ROLE ora_aspnet_Roles_ReportAccess; DROP ROLE ora_aspnet_Roles_FullAccess; -- Drop functions DROP FUNCTION ora_aspnet_UIR_IsUserInRole; DROP FUNCTION ora_aspnet_UIR_GetRolesForUser; DROP FUNCTION ora_aspnet_Roles_CreateRole; DROP FUNCTION ora_aspnet_Roles_DeleteRole; DROP FUNCTION ora_aspnet_Roles_RoleExists; DROP FUNCTION ora_aspnet_UIR_AddUsersToRoles; DROP FUNCTION ora_aspnet_UIR_RemUsersFmRoles; DROP FUNCTION ora_aspnet_UIR_GetUsersInRoles; DROP FUNCTION ora_aspnet_UIR_FindUsersInRole; DROP FUNCTION ora_aspnet_Roles_GetAllRoles; DROP PACKAGE ORA_ASPNET_ROLES_PKG; -- Drop views DROP VIEW ora_vw_aspnet_Roles; DROP VIEW ora_vw_aspnet_UIR; -- Drop tables DROP TABLE ora_aspnet_UsersInRoles; DROP TABLE ora_aspnet_Roles;
Ms-Dos/Windows
Unix
Write backup
jsp File Browser version 1.2 by
www.vonloesch.de