SG11201809909RA - User permission data query method and apparatus, electronic device and medium - Google Patents

User permission data query method and apparatus, electronic device and medium

Info

Publication number
SG11201809909RA
SG11201809909RA SG11201809909RA SG11201809909RA SG11201809909RA SG 11201809909R A SG11201809909R A SG 11201809909RA SG 11201809909R A SG11201809909R A SG 11201809909RA SG 11201809909R A SG11201809909R A SG 11201809909RA SG 11201809909R A SG11201809909R A SG 11201809909RA
Authority
SG
Singapore
Prior art keywords
data
obtaining
staff identification
permission
management
Prior art date
Application number
SG11201809909RA
Inventor
Chao Dong
Yaozhang Chen
Junfei Song
Yongjia He
Original Assignee
Ping An Technology Shenzhen Co Ltd
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by Ping An Technology Shenzhen Co Ltd filed Critical Ping An Technology Shenzhen Co Ltd
Publication of SG11201809909RA publication Critical patent/SG11201809909RA/en

Links

Classifications

    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F21/00—Security arrangements for protecting computers, components thereof, programs or data against unauthorised activity
    • G06F21/60—Protecting data
    • G06F21/62—Protecting access to data via a platform, e.g. using keys or access control rules
    • G06F21/6218—Protecting access to data via a platform, e.g. using keys or access control rules to a system of files or objects, e.g. local or distributed file system or database
    • G06F21/6227—Protecting access to data via a platform, e.g. using keys or access control rules to a system of files or objects, e.g. local or distributed file system or database where protection concerns the structure of data, e.g. records, types, queries
    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/22—Indexing; Data structures therefor; Storage structures
    • G06F16/2282—Tablespace storage structures; Management thereof
    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/24—Querying
    • G06F16/245—Query processing
    • G06F16/2455—Query execution
    • G06F16/24553—Query execution of query operations
    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/24—Querying
    • G06F16/248—Presentation of query results
    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/28—Databases characterised by their database models, e.g. relational or object models
    • G06F16/284—Relational databases
    • G06F16/288—Entity relationship models
    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F21/00—Security arrangements for protecting computers, components thereof, programs or data against unauthorised activity
    • G06F21/60—Protecting data
    • G06F21/602—Providing cryptographic facilities or services
    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F21/00—Security arrangements for protecting computers, components thereof, programs or data against unauthorised activity
    • G06F21/60—Protecting data
    • G06F21/604—Tools and structures for managing or administering access control systems
    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
    • G06Q10/00—Administration; Management
    • G06Q10/10—Office automation; Time management
    • G06Q10/105—Human resources
    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F2221/00—Indexing scheme relating to security arrangements for protecting computers, components thereof, programs or data against unauthorised activity
    • G06F2221/21—Indexing scheme relating to G06F21/00 and subgroups addressing additional information or applications relating to security arrangements for protecting computers, components thereof, programs or data against unauthorised activity
    • G06F2221/2141—Access rights, e.g. capability lists, access control lists, access tables, access matrices

Landscapes

  • Engineering & Computer Science (AREA)
  • Theoretical Computer Science (AREA)
  • Physics & Mathematics (AREA)
  • General Physics & Mathematics (AREA)
  • General Engineering & Computer Science (AREA)
  • Databases & Information Systems (AREA)
  • Software Systems (AREA)
  • Data Mining & Analysis (AREA)
  • Bioethics (AREA)
  • Computer Security & Cryptography (AREA)
  • Computer Hardware Design (AREA)
  • General Health & Medical Sciences (AREA)
  • Health & Medical Sciences (AREA)
  • Business, Economics & Management (AREA)
  • Human Resources & Organizations (AREA)
  • Computational Linguistics (AREA)
  • Automation & Control Theory (AREA)
  • Entrepreneurship & Innovation (AREA)
  • Strategic Management (AREA)
  • Economics (AREA)
  • Operations Research (AREA)
  • Quality & Reliability (AREA)
  • Tourism & Hospitality (AREA)
  • General Business, Economics & Management (AREA)
  • Marketing (AREA)
  • Storage Device Security (AREA)
  • Management, Administration, Business Operations System, And Electronic Commerce (AREA)
  • Information Retrieval, Db Structures And Fs Structures Therefor (AREA)

Abstract

The present solution is applicable to the technical field of data management, and provides a user permission data query method and device, an electronic device and a medium. The method includes the steps of: obtaining a first data table including staff identification numbers and departments corresponding to the staff identification numbers, and obtaining a second data table including a correspondence relationship among the staff identification numbers, roles, and administration authority information; obtaining, from the second data table, a plurality of data records having the same staff identification number and the same role, calculating an MD5 value corresponding to the staff identification number and the role, and then storing a correspondence relationship among the staff identification number, the role, and the MD5 value in a third data table; screening various MD5 values that are different from each other, and obtaining the management departments and the management staffs respectively corresponding to the various MD5 values based on the associated data tables; obtaining a MD5 value corresponding to the permission query request and determining the management departments and the management staffs corresponding to the MD5 value as permission data of a user, when a permission query request is received. The present solution has greatly improved the performance of a system and query efficiency of the permission data. FIG. 1
SG11201809909RA 2017-08-17 2017-09-29 User permission data query method and apparatus, electronic device and medium SG11201809909RA (en)

Applications Claiming Priority (2)

Application Number Priority Date Filing Date Title
CN201710707849.6A CN107545047B (en) 2017-08-17 2017-08-17 The querying method and terminal device of user right data
PCT/CN2017/104532 WO2019033519A1 (en) 2017-08-17 2017-09-29 User permission data query method and apparatus, electronic device, and medium

Publications (1)

Publication Number Publication Date
SG11201809909RA true SG11201809909RA (en) 2019-03-28

Family

ID=60957518

Family Applications (1)

Application Number Title Priority Date Filing Date
SG11201809909RA SG11201809909RA (en) 2017-08-17 2017-09-29 User permission data query method and apparatus, electronic device and medium

Country Status (5)

Country Link
US (1) US11281793B2 (en)
JP (1) JP6634527B2 (en)
CN (1) CN107545047B (en)
SG (1) SG11201809909RA (en)
WO (1) WO2019033519A1 (en)

Families Citing this family (31)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN108510238A (en) * 2018-03-12 2018-09-07 平安普惠企业管理有限公司 Compensation data processing method, device, computer equipment and storage medium
CN108595924B (en) * 2018-04-28 2022-08-02 平安科技（深圳）有限公司 Business authority management method and device, computer equipment and storage medium
CN110147384B (en) * 2019-04-17 2023-06-20 平安科技（深圳）有限公司 Data search model establishment method, device, computer equipment and storage medium
CN110334143A (en) * 2019-05-23 2019-10-15 深圳壹账通智能科技有限公司 Method for exhibiting data, device, computer equipment and storage medium
CN110457540B (en) * 2019-06-28 2020-07-14 卓尔智联(武汉)研究院有限公司 Data query method, service platform, terminal device and storage medium
CN110717174A (en) * 2019-08-28 2020-01-21 上海建工电子商务有限公司 User account setting method and device applied to e-commerce platform
CN111027032B (en) * 2019-11-13 2022-07-26 北京字节跳动网络技术有限公司 Authority management method, device, medium and electronic equipment
CN110992005B (en) * 2019-12-23 2024-02-06 普元信息技术股份有限公司 Method and system for realizing data authority control processing in big data application
CN111310166A (en) * 2020-01-17 2020-06-19 深圳木成林科技有限公司 Authority management method, device, equipment and storage medium
CN111459937B (en) * 2020-03-27 2024-06-07 中国平安人寿保险股份有限公司 Data table association method, device, server and storage medium
CN111428212B (en) * 2020-04-15 2023-05-05 上海嘉银金融科技股份有限公司 Data visualization system and data authority management method thereof
CN111651738B (en) * 2020-04-28 2023-06-27 中国科学院计算机网络信息中心 Fine-grained role authority unified management method based on front-end and back-end separation architecture and electronic device
CN113779517A (en) * 2020-06-09 2021-12-10 武汉斗鱼鱼乐网络科技有限公司 Authority obtaining method, device, equipment and storage medium
CN111737291B (en) * 2020-06-11 2023-07-21 青岛海尔科技有限公司 Method, device and database for inquiring equipment information
CN111859044A (en) * 2020-07-30 2020-10-30 深圳市元征科技股份有限公司 Data query processing method, system and related equipment
CN112000701B (en) * 2020-08-27 2023-11-28 中国平安财产保险股份有限公司 Method, device, equipment and storage medium for data query
CN111988338B (en) * 2020-09-07 2022-06-24 华侨大学 Permission-controllable Internet of things cloud platform based on block chain and data interaction method
CN112182011B (en) * 2020-09-28 2023-08-15 中国平安财产保险股份有限公司 Data operation method, device, electronic equipment and storage medium
CN113177070B (en) * 2021-05-17 2022-08-12 中移智行网络科技有限公司 Information query method, device and related equipment
CN113806406A (en) * 2021-09-18 2021-12-17 王剑 Diagnosis and treatment data storage method, query method and related device
CN113761009A (en) * 2021-11-09 2021-12-07 深圳市明源云科技有限公司 Personnel selection method, system, device and computer readable storage medium
CN114065161B (en) * 2021-11-22 2024-08-20 京东方科技集团股份有限公司 Authority control method and system for management platform, management platform and storage medium
CN114372249A (en) * 2022-03-21 2022-04-19 北京纷扬科技有限责任公司 Data authority control method and device based on authority codes
CN114710342B (en) * 2022-03-29 2024-04-12 上海掌门科技有限公司 Community management method, equipment, medium and program product
CN115189932B (en) * 2022-06-30 2024-04-02 龙芯中科(太原)技术有限公司 Rights management method, device, electronic equipment and readable storage medium
CN115080545A (en) * 2022-06-30 2022-09-20 北京亚控科技发展有限公司 Twin and subscription method and device for current state of personnel
CN115952063B (en) * 2023-03-13 2023-06-23 杭州天谷信息科技有限公司 Method and system for monitoring enterprise and authorized personnel relationship change
CN117216137B (en) * 2023-08-30 2024-04-26 建银工程咨询有限责任公司 Multidimensional information fusion display method and device
CN117251605B (en) * 2023-09-28 2024-05-10 武汉贝塔世纪科技有限公司 Multi-source data query method and system based on deep learning
CN117436811B (en) * 2023-11-01 2024-05-07 成都安美勤信息技术股份有限公司 Electronic bill management method and system based on privacy protection
CN118395418A (en) * 2024-06-27 2024-07-26 天津科电石化科技发展有限公司 Shiro-based user permission security management method and device, electronic equipment and medium

Family Cites Families (19)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US6279007B1 (en) * 1998-11-30 2001-08-21 Microsoft Corporation Architecture for managing query friendly hierarchical values
JP4334074B2 (en) * 1999-08-05 2009-09-16 株式会社リコー Information management system, authority management method, and storage medium
JP2008123124A (en) * 2006-11-09 2008-05-29 Toshiba Corp Database system, database access method, and database access program
US8528089B2 (en) * 2006-12-19 2013-09-03 Mcafee, Inc. Known files database for malware elimination
JP2009238191A (en) * 2008-03-28 2009-10-15 Mitsubishi Electric Corp Web application system
CN102346747B (en) * 2010-08-04 2013-02-13 鸿富锦精密工业（深圳）有限公司 Method for searching parameters in data model
US8626781B2 (en) * 2010-12-29 2014-01-07 Microsoft Corporation Priority hash index
US8965921B2 (en) * 2012-06-06 2015-02-24 Rackspace Us, Inc. Data management and indexing across a distributed database
US9378065B2 (en) * 2013-03-15 2016-06-28 Advanced Elemental Technologies, Inc. Purposeful computing
CN104573430B (en) * 2013-10-21 2018-05-18 华为技术有限公司 A kind of data access authority control method and device
CN104636643B (en) * 2013-11-07 2017-12-01 华为技术有限公司 Control method and device are presented in system interface content
US9590992B2 (en) * 2014-04-07 2017-03-07 Marin Litoiu Systems and methods of precision sharing of big data
US20160098573A1 (en) * 2014-10-03 2016-04-07 Zettaset, Inc. Securing a Distributed File System
CN105894159A (en) * 2014-12-03 2016-08-24 北京航天长峰科技工业集团有限公司 Implementation method of cross-domain and cross-platform user unified management system
CN105187365B (en) * 2015-06-04 2018-09-14 北京邮电大学 The access control method and device of based role and data item
CN106384057B (en) * 2016-04-27 2017-09-15 平安科技（深圳）有限公司 Data access authority recognition methods and device
CN106055967A (en) 2016-05-24 2016-10-26 福建星海通信科技有限公司 SAAS platform user organization permission management method and system
US10621370B2 (en) * 2016-05-27 2020-04-14 Intel Corporation Methods and apparatus to provide group-based row-level security for big data platforms
CN106228059A (en) * 2016-07-22 2016-12-14 南京航空航天大学 Based on three Yuans management and the role access control method of expansion

Also Published As

Publication number Publication date
US20210224412A1 (en) 2021-07-22
JP2019532370A (en) 2019-11-07
WO2019033519A1 (en) 2019-02-21
CN107545047A (en) 2018-01-05
JP6634527B2 (en) 2020-01-22
US11281793B2 (en) 2022-03-22
CN107545047B (en) 2019-07-19

Similar Documents

Publication Publication Date Title
SG11201809909RA (en) User permission data query method and apparatus, electronic device and medium
CN107733869B (en) Equipment identification method and device
SG10201810910YA (en) Data sharing method based on plurality of blockchains
JP5560367B2 (en) Method, system and server for managing dynamic information of friends in a network
TWI662426B (en) Method and device for distributed stream data processing
SG10201800100XA (en) Component tracking method and system
ATE474277T1 (en) METHOD AND DEVICE FOR HANDLING THE STORAGE OF USER DATA IN 3G DIGITAL CELLULAR TELECOMMUNICATIONS SYSTEMS
CN113051347B (en) Method, system, equipment and storage medium for synchronizing data between heterogeneous databases
MY178261A (en) Method, system, and apparatus for exchanging data between client devices
CN109062936B (en) Data query method, computer readable storage medium and terminal equipment
TW201423377A (en) Data storage and system thereof
CN106202305A (en) A kind of log processing method, device and Database Systems
CN106202400A (en) A kind of big data collection and analysis method complaining behavior
WO2016100545A8 (en) Computer servers for datacenter management
CN102609464A (en) Method and device for associative table query of MONGODB shards
SG11201805866UA (en) Permission management and resource control method and apparatus
CN104484958A (en) Express delivery pickup method and system for intelligent express delivery cabinet
GB2565482A (en) Attribute matching
CN105242873B (en) The acquisition of the performance data of cloud computing system and storage method and device
CN114637811A (en) Data table entity relation graph generation method, device, equipment and storage medium
WO2014088892A8 (en) Methods, devices and systems for the generation of requests for quotes from aggregated construction-related and permitting information
CN103136336B (en) The integrated system and method for a kind of mass data
SG11201805503TA (en) Method of inputting document information, device, server, and storage medium
CN106202121B (en) Data storage and derived method and apparatus
CN205249277U (en) Data monitoring management system