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
- Intellectual Property
- Life Sciences
- Materials
- Tech Scout
- Unparalleled Data Quality
- Higher Quality Content
- 60% Fewer Hallucinations
Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic, Popular Technical Reports.
© 2025 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap|About US| Contact US: help@patsnap.com