Data filtering method and system based on user permission
The invention discloses a data filtering method and system based on user permission, and the method comprises the steps: creating a permission organization table which is used for mapping the architecture of business organization nodes with different permissions in a business system; adding a permis...
Gespeichert in:
| Hauptverfasser: | , , |
|---|---|
| Format: | Patent |
| Sprache: | chi ; eng |
| Schlagworte: | |
| Online-Zugang: | Volltext bestellen |
| Tags: |
Tag hinzufügen
Keine Tags, Fügen Sie den ersten Tag hinzu!
|
| container_end_page | |
|---|---|
| container_issue | |
| container_start_page | |
| container_title | |
| container_volume | |
| creator | SUN BAOYUE YAO ZHANLONG MIN GANG |
| description | The invention discloses a data filtering method and system based on user permission, and the method comprises the steps: creating a permission organization table which is used for mapping the architecture of business organization nodes with different permissions in a business system; adding a permission attribution dimension column aiming at the business data table to describe a corresponding business organization node in a permission organization table to which the permission of each row of data belongs; when a current user executes data query or modification, generating an SQL statement according to a query or modification instruction; and according to the business organization node of the current user, adding a filtering condition aiming at the permission attribution dimension column in the SQL statement, and according to the filtering condition, limiting the data to be queried or modified to be the data owned by the current user to be the data owned by the data permission, and executing the modified query |
| format | Patent |
| fullrecord | <record><control><sourceid>epo_EVB</sourceid><recordid>TN_cdi_epo_espacenet_CN114428802A</recordid><sourceformat>XML</sourceformat><sourcesystem>PC</sourcesystem><sourcerecordid>CN114428802A</sourcerecordid><originalsourceid>FETCH-epo_espacenet_CN114428802A3</originalsourceid><addsrcrecordid>eNrjZLB0SSxJVEjLzClJLcrMS1fITS3JyE9RSMxLUSiuLC5JzVVISixOTVHIz1MoLU4tUihILcrNLC7OzM_jYWBNS8wpTuWF0twMim6uIc4euqkF-fGpxQWJyal5qSXxzn6GhiYmRhYWBkaOxsSoAQAxDi6X</addsrcrecordid><sourcetype>Open Access Repository</sourcetype><iscdi>true</iscdi><recordtype>patent</recordtype></control><display><type>patent</type><title>Data filtering method and system based on user permission</title><source>esp@cenet</source><creator>SUN BAOYUE ; YAO ZHANLONG ; MIN GANG</creator><creatorcontrib>SUN BAOYUE ; YAO ZHANLONG ; MIN GANG</creatorcontrib><description>The invention discloses a data filtering method and system based on user permission, and the method comprises the steps: creating a permission organization table which is used for mapping the architecture of business organization nodes with different permissions in a business system; adding a permission attribution dimension column aiming at the business data table to describe a corresponding business organization node in a permission organization table to which the permission of each row of data belongs; when a current user executes data query or modification, generating an SQL statement according to a query or modification instruction; and according to the business organization node of the current user, adding a filtering condition aiming at the permission attribution dimension column in the SQL statement, and according to the filtering condition, limiting the data to be queried or modified to be the data owned by the current user to be the data owned by the data permission, and executing the modified query</description><language>chi ; eng</language><subject>CALCULATING ; COMPUTING ; COUNTING ; ELECTRIC DIGITAL DATA PROCESSING ; PHYSICS</subject><creationdate>2022</creationdate><oa>free_for_read</oa><woscitedreferencessubscribed>false</woscitedreferencessubscribed></display><links><openurl>$$Topenurl_article</openurl><openurlfulltext>$$Topenurlfull_article</openurlfulltext><thumbnail>$$Tsyndetics_thumb_exl</thumbnail><linktohtml>$$Uhttps://worldwide.espacenet.com/publicationDetails/biblio?FT=D&date=20220503&DB=EPODOC&CC=CN&NR=114428802A$$EHTML$$P50$$Gepo$$Hfree_for_read</linktohtml><link.rule.ids>230,308,780,885,25564,76547</link.rule.ids><linktorsrc>$$Uhttps://worldwide.espacenet.com/publicationDetails/biblio?FT=D&date=20220503&DB=EPODOC&CC=CN&NR=114428802A$$EView_record_in_European_Patent_Office$$FView_record_in_$$GEuropean_Patent_Office$$Hfree_for_read</linktorsrc></links><search><creatorcontrib>SUN BAOYUE</creatorcontrib><creatorcontrib>YAO ZHANLONG</creatorcontrib><creatorcontrib>MIN GANG</creatorcontrib><title>Data filtering method and system based on user permission</title><description>The invention discloses a data filtering method and system based on user permission, and the method comprises the steps: creating a permission organization table which is used for mapping the architecture of business organization nodes with different permissions in a business system; adding a permission attribution dimension column aiming at the business data table to describe a corresponding business organization node in a permission organization table to which the permission of each row of data belongs; when a current user executes data query or modification, generating an SQL statement according to a query or modification instruction; and according to the business organization node of the current user, adding a filtering condition aiming at the permission attribution dimension column in the SQL statement, and according to the filtering condition, limiting the data to be queried or modified to be the data owned by the current user to be the data owned by the data permission, and executing the modified query</description><subject>CALCULATING</subject><subject>COMPUTING</subject><subject>COUNTING</subject><subject>ELECTRIC DIGITAL DATA PROCESSING</subject><subject>PHYSICS</subject><fulltext>true</fulltext><rsrctype>patent</rsrctype><creationdate>2022</creationdate><recordtype>patent</recordtype><sourceid>EVB</sourceid><recordid>eNrjZLB0SSxJVEjLzClJLcrMS1fITS3JyE9RSMxLUSiuLC5JzVVISixOTVHIz1MoLU4tUihILcrNLC7OzM_jYWBNS8wpTuWF0twMim6uIc4euqkF-fGpxQWJyal5qSXxzn6GhiYmRhYWBkaOxsSoAQAxDi6X</recordid><startdate>20220503</startdate><enddate>20220503</enddate><creator>SUN BAOYUE</creator><creator>YAO ZHANLONG</creator><creator>MIN GANG</creator><scope>EVB</scope></search><sort><creationdate>20220503</creationdate><title>Data filtering method and system based on user permission</title><author>SUN BAOYUE ; YAO ZHANLONG ; MIN GANG</author></sort><facets><frbrtype>5</frbrtype><frbrgroupid>cdi_FETCH-epo_espacenet_CN114428802A3</frbrgroupid><rsrctype>patents</rsrctype><prefilter>patents</prefilter><language>chi ; eng</language><creationdate>2022</creationdate><topic>CALCULATING</topic><topic>COMPUTING</topic><topic>COUNTING</topic><topic>ELECTRIC DIGITAL DATA PROCESSING</topic><topic>PHYSICS</topic><toplevel>online_resources</toplevel><creatorcontrib>SUN BAOYUE</creatorcontrib><creatorcontrib>YAO ZHANLONG</creatorcontrib><creatorcontrib>MIN GANG</creatorcontrib><collection>esp@cenet</collection></facets><delivery><delcategory>Remote Search Resource</delcategory><fulltext>fulltext_linktorsrc</fulltext></delivery><addata><au>SUN BAOYUE</au><au>YAO ZHANLONG</au><au>MIN GANG</au><format>patent</format><genre>patent</genre><ristype>GEN</ristype><title>Data filtering method and system based on user permission</title><date>2022-05-03</date><risdate>2022</risdate><abstract>The invention discloses a data filtering method and system based on user permission, and the method comprises the steps: creating a permission organization table which is used for mapping the architecture of business organization nodes with different permissions in a business system; adding a permission attribution dimension column aiming at the business data table to describe a corresponding business organization node in a permission organization table to which the permission of each row of data belongs; when a current user executes data query or modification, generating an SQL statement according to a query or modification instruction; and according to the business organization node of the current user, adding a filtering condition aiming at the permission attribution dimension column in the SQL statement, and according to the filtering condition, limiting the data to be queried or modified to be the data owned by the current user to be the data owned by the data permission, and executing the modified query</abstract><oa>free_for_read</oa></addata></record> |
| fulltext | fulltext_linktorsrc |
| identifier | |
| ispartof | |
| issn | |
| language | chi ; eng |
| recordid | cdi_epo_espacenet_CN114428802A |
| source | esp@cenet |
| subjects | CALCULATING COMPUTING COUNTING ELECTRIC DIGITAL DATA PROCESSING PHYSICS |
| title | Data filtering method and system based on user permission |
| url | https://sfx.bib-bvb.de/sfx_tum?ctx_ver=Z39.88-2004&ctx_enc=info:ofi/enc:UTF-8&ctx_tim=2025-01-07T06%3A15%3A14IST&url_ver=Z39.88-2004&url_ctx_fmt=infofi/fmt:kev:mtx:ctx&rfr_id=info:sid/primo.exlibrisgroup.com:primo3-Article-epo_EVB&rft_val_fmt=info:ofi/fmt:kev:mtx:patent&rft.genre=patent&rft.au=SUN%20BAOYUE&rft.date=2022-05-03&rft_id=info:doi/&rft_dat=%3Cepo_EVB%3ECN114428802A%3C/epo_EVB%3E%3Curl%3E%3C/url%3E&disable_directlink=true&sfx.directlink=off&sfx.report_link=0&rft_id=info:oai/&rft_id=info:pmid/&rfr_iscdi=true |