System and method for unified management of mala user authority
A technology of user rights and management system, which is applied in the field of mala user rights unified management system, can solve problems such as distributed implementation difficulties, and achieve the effects of single sign-on, experience reduction, and improved security
- Summary
- Abstract
- Description
- Claims
- Application Information
AI Technical Summary
Problems solved by technology
Method used
Image
Examples
Embodiment
[0032] Create privilege system database script
[0033] createtablestaff(
[0034] StaffIDintauto_incrementprimarykey,
[0035] StaffNamevarchar(50) unique,
[0036] StaffPwdvarchar(50) notnull
[0037] )ENGINE=InnoDBDEFAULTCHARSET=gbk;
[0038] createtablerole(
[0039] RoleIDintauto_incrementprimarykey,
[0040] RoleNamevarchar(50) unique,
[0041] Descriptionvarchar(200)notnull
[0042] )ENGINE=InnoDBDEFAULTCHARSET=gbk;
[0043] createtablestaffrole(
[0044] IDintauto_incrementprimarykey,
[0045] RoleIDintnotnull,
[0046] Staff ID int not null,
[0047] CONSTRAINT staffrole_role_fkFOREIGNKEY(RoleID) REFERENCESrole(RoleID),
[0048] CONSTRAINTstaffrole_staff_fkFOREIGNKEY(StaffID)REFERENCESstaff(StaffID)
[0049] )ENGINE=InnoDBDEFAULTCHARSET=gbk;
[0050] createtableauth(
[0051] AuthIDintauto_incrementprimarykey.
[0052] ModuleDintNotNull,
[0053] FunctionIDintnotnull,
[0054] CONSTRAINTauthmodule_fkFOREIGNKEY(ModuleID) REFERENCESmodule(ModuleID),
...
PUM
Abstract
Description
Claims
Application Information
- R&D Engineer
- R&D Manager
- IP Professional
- Industry Leading Data Capabilities
- Powerful AI technology
- Patent DNA Extraction
Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic, Popular Technical Reports.
© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap|About US| Contact US: help@patsnap.com