METHOD AND SYSTEM FOR USING FINE-GRAINED ACCESS CONTROL (FGAC) TO CONTROL ACCESS TO DATA IN A DATABASE
A method and system for controlling access to data stored in a table of a database are provided. The method includes marking the table of the database as being protected with fine-grained access control (FGAC), creating a system authorization class for the table of the database, the system authoriza...
Gespeichert in:
| Hauptverfasser: | , , , , , |
|---|---|
| Format: | Patent |
| Sprache: | 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 | LUNIEWSKI ALLEN WILLIAM BIRD PAUL MILLER CHEN YAOING STEPHEN KIERNAN GEORGE GERALD LOGAN SCOTT IAN RJAIBI WALID |
| description | A method and system for controlling access to data stored in a table of a database are provided. The method includes marking the table of the database as being protected with fine-grained access control (FGAC), creating a system authorization class for the table of the database, the system authorization class having a default row authorization that prevents access to all rows in the table, the system authorization class being unmodifiable, creating a user authorization class for the table of the database, the user authorization class having a default row authorization that prevents access to all rows in the table, the user authorization class being modifiable, and associating the system authorization class and the user authorization class with the table of the database. |
| format | Patent |
| fullrecord | <record><control><sourceid>epo_EVB</sourceid><recordid>TN_cdi_epo_espacenet_US2009182747A1</recordid><sourceformat>XML</sourceformat><sourcesystem>PC</sourcesystem><sourcerecordid>US2009182747A1</sourcerecordid><originalsourceid>FETCH-epo_espacenet_US2009182747A13</originalsourceid><addsrcrecordid>eNqNij0LwjAUALM4iPofHrjoUGirUB2f-WrAJpCXDk6lSDqJFur_xyDF2emO45ZsaGSonQC0AuhGQTagnIeWjNWgjJWZ9piQDs4lEXBng3dX2CmNfA_B_co8pCIwIBgL-LULklyzxdA_priZuWJbJQOvszi-ujiN_T0-47trqczzc3Eqq2OFxeG_6wMCTDT1</addsrcrecordid><sourcetype>Open Access Repository</sourcetype><iscdi>true</iscdi><recordtype>patent</recordtype></control><display><type>patent</type><title>METHOD AND SYSTEM FOR USING FINE-GRAINED ACCESS CONTROL (FGAC) TO CONTROL ACCESS TO DATA IN A DATABASE</title><source>esp@cenet</source><creator>LUNIEWSKI ALLEN WILLIAM ; BIRD PAUL MILLER ; CHEN YAOING STEPHEN ; KIERNAN GEORGE GERALD ; LOGAN SCOTT IAN ; RJAIBI WALID</creator><creatorcontrib>LUNIEWSKI ALLEN WILLIAM ; BIRD PAUL MILLER ; CHEN YAOING STEPHEN ; KIERNAN GEORGE GERALD ; LOGAN SCOTT IAN ; RJAIBI WALID</creatorcontrib><description>A method and system for controlling access to data stored in a table of a database are provided. The method includes marking the table of the database as being protected with fine-grained access control (FGAC), creating a system authorization class for the table of the database, the system authorization class having a default row authorization that prevents access to all rows in the table, the system authorization class being unmodifiable, creating a user authorization class for the table of the database, the user authorization class having a default row authorization that prevents access to all rows in the table, the user authorization class being modifiable, and associating the system authorization class and the user authorization class with the table of the database.</description><language>eng</language><subject>CALCULATING ; COMPUTING ; COUNTING ; ELECTRIC DIGITAL DATA PROCESSING ; PHYSICS</subject><creationdate>2009</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=20090716&DB=EPODOC&CC=US&NR=2009182747A1$$EHTML$$P50$$Gepo$$Hfree_for_read</linktohtml><link.rule.ids>230,308,780,885,25563,76318</link.rule.ids><linktorsrc>$$Uhttps://worldwide.espacenet.com/publicationDetails/biblio?FT=D&date=20090716&DB=EPODOC&CC=US&NR=2009182747A1$$EView_record_in_European_Patent_Office$$FView_record_in_$$GEuropean_Patent_Office$$Hfree_for_read</linktorsrc></links><search><creatorcontrib>LUNIEWSKI ALLEN WILLIAM</creatorcontrib><creatorcontrib>BIRD PAUL MILLER</creatorcontrib><creatorcontrib>CHEN YAOING STEPHEN</creatorcontrib><creatorcontrib>KIERNAN GEORGE GERALD</creatorcontrib><creatorcontrib>LOGAN SCOTT IAN</creatorcontrib><creatorcontrib>RJAIBI WALID</creatorcontrib><title>METHOD AND SYSTEM FOR USING FINE-GRAINED ACCESS CONTROL (FGAC) TO CONTROL ACCESS TO DATA IN A DATABASE</title><description>A method and system for controlling access to data stored in a table of a database are provided. The method includes marking the table of the database as being protected with fine-grained access control (FGAC), creating a system authorization class for the table of the database, the system authorization class having a default row authorization that prevents access to all rows in the table, the system authorization class being unmodifiable, creating a user authorization class for the table of the database, the user authorization class having a default row authorization that prevents access to all rows in the table, the user authorization class being modifiable, and associating the system authorization class and the user authorization class with the table of the database.</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>2009</creationdate><recordtype>patent</recordtype><sourceid>EVB</sourceid><recordid>eNqNij0LwjAUALM4iPofHrjoUGirUB2f-WrAJpCXDk6lSDqJFur_xyDF2emO45ZsaGSonQC0AuhGQTagnIeWjNWgjJWZ9piQDs4lEXBng3dX2CmNfA_B_co8pCIwIBgL-LULklyzxdA_priZuWJbJQOvszi-ujiN_T0-47trqczzc3Eqq2OFxeG_6wMCTDT1</recordid><startdate>20090716</startdate><enddate>20090716</enddate><creator>LUNIEWSKI ALLEN WILLIAM</creator><creator>BIRD PAUL MILLER</creator><creator>CHEN YAOING STEPHEN</creator><creator>KIERNAN GEORGE GERALD</creator><creator>LOGAN SCOTT IAN</creator><creator>RJAIBI WALID</creator><scope>EVB</scope></search><sort><creationdate>20090716</creationdate><title>METHOD AND SYSTEM FOR USING FINE-GRAINED ACCESS CONTROL (FGAC) TO CONTROL ACCESS TO DATA IN A DATABASE</title><author>LUNIEWSKI ALLEN WILLIAM ; BIRD PAUL MILLER ; CHEN YAOING STEPHEN ; KIERNAN GEORGE GERALD ; LOGAN SCOTT IAN ; RJAIBI WALID</author></sort><facets><frbrtype>5</frbrtype><frbrgroupid>cdi_FETCH-epo_espacenet_US2009182747A13</frbrgroupid><rsrctype>patents</rsrctype><prefilter>patents</prefilter><language>eng</language><creationdate>2009</creationdate><topic>CALCULATING</topic><topic>COMPUTING</topic><topic>COUNTING</topic><topic>ELECTRIC DIGITAL DATA PROCESSING</topic><topic>PHYSICS</topic><toplevel>online_resources</toplevel><creatorcontrib>LUNIEWSKI ALLEN WILLIAM</creatorcontrib><creatorcontrib>BIRD PAUL MILLER</creatorcontrib><creatorcontrib>CHEN YAOING STEPHEN</creatorcontrib><creatorcontrib>KIERNAN GEORGE GERALD</creatorcontrib><creatorcontrib>LOGAN SCOTT IAN</creatorcontrib><creatorcontrib>RJAIBI WALID</creatorcontrib><collection>esp@cenet</collection></facets><delivery><delcategory>Remote Search Resource</delcategory><fulltext>fulltext_linktorsrc</fulltext></delivery><addata><au>LUNIEWSKI ALLEN WILLIAM</au><au>BIRD PAUL MILLER</au><au>CHEN YAOING STEPHEN</au><au>KIERNAN GEORGE GERALD</au><au>LOGAN SCOTT IAN</au><au>RJAIBI WALID</au><format>patent</format><genre>patent</genre><ristype>GEN</ristype><title>METHOD AND SYSTEM FOR USING FINE-GRAINED ACCESS CONTROL (FGAC) TO CONTROL ACCESS TO DATA IN A DATABASE</title><date>2009-07-16</date><risdate>2009</risdate><abstract>A method and system for controlling access to data stored in a table of a database are provided. The method includes marking the table of the database as being protected with fine-grained access control (FGAC), creating a system authorization class for the table of the database, the system authorization class having a default row authorization that prevents access to all rows in the table, the system authorization class being unmodifiable, creating a user authorization class for the table of the database, the user authorization class having a default row authorization that prevents access to all rows in the table, the user authorization class being modifiable, and associating the system authorization class and the user authorization class with the table of the database.</abstract><oa>free_for_read</oa></addata></record> |
| fulltext | fulltext_linktorsrc |
| identifier | |
| ispartof | |
| issn | |
| language | eng |
| recordid | cdi_epo_espacenet_US2009182747A1 |
| source | esp@cenet |
| subjects | CALCULATING COMPUTING COUNTING ELECTRIC DIGITAL DATA PROCESSING PHYSICS |
| title | METHOD AND SYSTEM FOR USING FINE-GRAINED ACCESS CONTROL (FGAC) TO CONTROL ACCESS TO DATA IN A DATABASE |
| url | https://sfx.bib-bvb.de/sfx_tum?ctx_ver=Z39.88-2004&ctx_enc=info:ofi/enc:UTF-8&ctx_tim=2025-01-10T12%3A05%3A23IST&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=LUNIEWSKI%20ALLEN%20WILLIAM&rft.date=2009-07-16&rft_id=info:doi/&rft_dat=%3Cepo_EVB%3EUS2009182747A1%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 |