ASP. NET menu-level permission management Oracle Database Implementation Analysis

Permission management, menu management, general framework, Oracle database, ASP. NET, Oracle function, Oracle package

1. Table Creation

User permission series Table menu Log Series table

Spool ora_tables.logprompt permission classification table prompt creating table accounts_permissioncategoriesprompt ======================== ============== prompt @ accounts_permissioncategories.tabprompt permission table prompt creating table accounts_permissionsprompt ======================== ====================== prompt @ accounts_permissions.tabprompt role permission corresponding to the table prompt creating table accounts_rolepermissionsprompt ============ ====================== prompt accounts_rolepermissions.tabprompt role table prompt creating table accounts_rolesprompt = ====================== prompt accounts_roles.tabprompt ================================== prompt @ accounts_userroles.tabprompt User table prompt creating table accounts_usersprompt ========================== prompt @ accounts_users.tabprompt log table prompt creating table s_logprompt ============================ prompt s_log.tabprompt User Logon Information log prompt creating table s_loguserprompt ======== ====================== prompt @ s_loguser.tabpromptprompt creating table s_treeprompt ========== ====== prompt menu Table @ s_tree.tabspool off

2. Create an Oracle package

promptprompt Creating package PKG_TESTprompt =========================prompt@@pkg_test.spc

3. Create Oracle Functions

------------------------------------------- Created by xjy on 2010-11-7, 22:53:21 create permission prompt creating function f_acc_createpermissionprompt ======================== ========= prompt @ f_acc_createpermission.fncprompt permission: role-specific action prompt creating function f_addpermissiontoroleprompt ================ ============================== prompt @ f_addpermissiontorole.fncprompt role-specific operations on prompt creating function f_addusertoroleprompt ========== ==================== prompt @ f_addusertorole.fncprompt role clear permission prompt creating function f_clearpermissionsfromroleprompt = ========================================================== = prompt @ f_clearpermissionsfromrole.fncprompt create permission the same as f_acc_createpermissionprompt creating function f_createpermissionprompt ================== ========= prompt @ f_createpermission.fncprompt create permission class prompt creating function f_createpermissioncategoryprompt ================ ==================== prompt @ f_createpermissioncategory.fncprompt create role prompt creating function f_createroleprompt ====== ================================== prompt @ f_createrole.fncprompt create user prompt creating function f_createuserprompt ====== ================================ prompt @ f_createuser.fncprompt Delete permission prompt creating function f_deletepermissionprompt ====== ========================== prompt f_deletepermission.fncprompt Delete permission category prompt creating function f_deletepermissioncategoryprompt ========================================== ===== prompt @ f_deletepermissioncategory.fncprompt Delete role prompt creating function f_deleteroleprompt ============== ===== prompt @ f_deleterole.fncprompt delete user prompt creating function f_deleteuserprompt ================ ===== prompt @ f_deleteuser.fncprompt get all roles prompt creating function f_getallrolesprompt ============== ======= prompt @ f_getallroles.fncprompt enter the user ID to obtain the user's valid Permission name prompt creating function f_get1_tivepermissionlistprompt ==================== ========================== prompt f_get1_tivepermissionlist.fncprompt enter the user ID to obtain valid permissions of the user idprompt creating function f_geteffectivepermissionlistidprompt ================================== ============ prompt @ brief enter the role to obtain the role's permissions prompt creating function f_getnopermissionlistprompt ======== ==================== prompt @ f_getnopermissionlist.fncprompt permission classification prompt creating function f_getpermissioncategoriesprompt = ========================================================== = prompt @ f_getpermissioncategories.fncprompt detailed permission classification (description) prompt creating function f_getpermissioncategorydetailsprompt ================================ ============ prompt @ f_getpermissioncategorydetails.fncprompt detailed permission (description) prompt creating function f_getpermissiondetailsprompt ================================== ==== prompt @ f_getpermissiondetails.fncprompt enter the role to obtain the permission list prompt creating function f_getpermissionlistprompt ====================== ============== prompt @ f_getpermissionlist.fncprompt obtain all permissions under the category change permission prompt creating function f_getpermissionsincategoryprompt ============ ==================================== prompt @ f_getpermissionsincategory.fncprompt details prompt creating function f_getroledetailsprompt ============================== prompt @ f_getroledetails.fncprompt obtain the user details prompt creating function f_getuserdetailsprompt ======================== ==== prompt @ f_getuserdetails.fncprompt obtain the user details using the user name prompt creating function f_getuserdetailsbyusernameprompt ====================== ======================== prompt @ f_getuserdetailsbyusername.fncprompt obtain the role prompt creating function f_getuserrolesprompt = ========================== prompt @ f_getuserroles.fncprompt obtain user details through fuzzy search prompt creating function f_getusersprompt ============================ prompt @ f_getusers.fncprompt obtain the user details prompt creating function f_getusersby?prompt ================================ === prompt @ f_getusersbydepart.fncprompt obtain the user details using the user type and keywords prompt creating function f_getusersbytypeprompt ==================== ============ prompt @ f_getusersbytype.fncprompt Delete the role and permission ing relationship prompt creating function f_removepermissionfromroleprompt ============== ============================== prompt f_removepermissionfromrole.fncprompt delete a user and role relation prompt creating function f_removeuserfromroleprompt ================================ === prompt @ f_removeuserfromrole.fncprompt set the password prompt creating function f_setpasswordprompt ================== ===== prompt @ f_setpassword.fncprompt test whether the user ID and password correspond to the correct prompt creating function f_testpasswordprompt ============ ============ prompt @ f_testpassword.fncprompt update permission Description Based on permission idprompt creating function f_updatepermissionprompt ================== ============================== prompt @ f_updatepermission.fncprompt update the role Description Based on the role idprompt creating function f_updateroleprompt ======== ============================== prompt @ f_updaterole.fncprompt updates user information based on user idprompt creating function f_updateuserprompt = ========================== prompt @ f_updateuser.fncprompt verify whether the prompt creating function is used based on the user name and password f_validateloginprompt ================================ prompt @ f_validatelogin.fncspool off

4. Create an oracle sequence Sequence

promptprompt Creating sequence SEQ_ACCOUNTS_PERMISSIONSprompt ==========================================prompt@@seq_accounts_permissions.seqpromptprompt Creating sequence SEQ_CREATEROLEprompt ================================prompt@@seq_createrole.seqpromptprompt Creating sequence SEQ_LOGprompt =========================prompt@@seq_log.seqpromptprompt Creating sequence SEQ_PERMCATEprompt ==============================prompt@@seq_permcate.seqpromptprompt Creating sequence SEQ_USERSprompt ===========================prompt@@seq_users.seq

5. Implemented

1) Add users

2) modify a user

3) Set User Roles

4) role management

5) permission management

6) Corresponding menu and permission (add menu)