KR101224822B1 - Ｃｒｍ 데이터베이스에서의 보안 뷰 - Google Patents

Ｃｒｍ 데이터베이스에서의 보안 뷰 Download PDF

Info

Publication number
KR101224822B1
KR101224822B1 KR1020050104436A KR20050104436A KR101224822B1 KR 101224822 B1 KR101224822 B1 KR 101224822B1 KR 1020050104436 A KR1020050104436 A KR 1020050104436A KR 20050104436 A KR20050104436 A KR 20050104436A KR 101224822 B1 KR101224822 B1 KR 101224822B1
Authority
KR
South Korea
Prior art keywords
user
database
row
business unit
view
Prior art date
Legal status (The legal status 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 status listed.)
Expired - Fee Related
Application number
KR1020050104436A
Other languages
English (en)
Korean (ko)
Other versions
KR20060071861A (ko
Inventor
민 팬
에드워드 에이. 마르티네즈
츠비 엠. 라이터
자스지트 신 그레왈
Original Assignee
마이크로소프트 코포레이션
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 마이크로소프트 코포레이션 filed Critical 마이크로소프트 코포레이션
Publication of KR20060071861A publication Critical patent/KR20060071861A/ko
Application granted granted Critical
Publication of KR101224822B1 publication Critical patent/KR101224822B1/ko
Anticipated expiration legal-status Critical
Expired - Fee Related legal-status Critical Current

Links

Images

Classifications

    • G—PHYSICS
    • G06—COMPUTING OR CALCULATING; COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F15/00—Digital computers in general; Data processing equipment in general
    • G—PHYSICS
    • G06—COMPUTING OR CALCULATING; 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
    • Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
    • Y10—TECHNICAL SUBJECTS COVERED BY FORMER USPC
    • Y10S—TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
    • Y10S707/00—Data processing: database and file management or data structures
    • Y10S707/99931—Database or file accessing
    • Y10S707/99939—Privileged access
    • Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
    • Y10—TECHNICAL SUBJECTS COVERED BY FORMER USPC
    • Y10S—TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
    • Y10S707/00—Data processing: database and file management or data structures
    • Y10S707/99941—Database schema or data structure
    • Y10S707/99943—Generating database or data structure, e.g. via user interface
    • Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
    • Y10—TECHNICAL SUBJECTS COVERED BY FORMER USPC
    • Y10S—TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
    • Y10S707/00—Data processing: database and file management or data structures
    • Y10S707/99951—File or database maintenance
    • Y10S707/99952—Coherency, e.g. same view to multiple users

Landscapes

  • Engineering & Computer Science (AREA)
  • Theoretical Computer Science (AREA)
  • Physics & Mathematics (AREA)
  • General Physics & Mathematics (AREA)
  • General Engineering & Computer Science (AREA)
  • Computer Hardware Design (AREA)
  • Bioethics (AREA)
  • Software Systems (AREA)
  • Computer Security & Cryptography (AREA)
  • General Health & Medical Sciences (AREA)
  • Health & Medical Sciences (AREA)
  • Databases & Information Systems (AREA)
  • Storage Device Security (AREA)
  • Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
KR1020050104436A 2004-12-22 2005-11-02 Ｃｒｍ 데이터베이스에서의 보안 뷰 Expired - Fee Related KR101224822B1 (ko)

Applications Claiming Priority (2)

Application Number Priority Date Filing Date Title
US11/020,446 US7562092B2 (en) 2004-12-22 2004-12-22 Secured views for a CRM database
US11/020,446 2004-12-22

Publications (2)

Publication Number Publication Date
KR20060071861A KR20060071861A (ko) 2006-06-27
KR101224822B1 true KR101224822B1 (ko) 2013-01-21

Family

ID=35998563

Family Applications (1)

Application Number Title Priority Date Filing Date
KR1020050104436A Expired - Fee Related KR101224822B1 (ko) 2004-12-22 2005-11-02 Ｃｒｍ 데이터베이스에서의 보안 뷰

Country Status (7)

Country Link
US (1) US7562092B2 (enExample)
EP (1) EP1675030A1 (enExample)
JP (1) JP4906340B2 (enExample)
KR (1) KR101224822B1 (enExample)
CN (1) CN1794232B (enExample)
AU (1) AU2005237168B2 (enExample)
CA (1) CA2526286A1 (enExample)

Families Citing this family (26)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US8019636B2 (en) * 2004-09-28 2011-09-13 International Business Machines Corporation Method, system and program product for planning and managing a call center study
US9160792B2 (en) * 2005-04-05 2015-10-13 International Business Machines Corporation On-demand global server load balancing system and method of use
US8676845B2 (en) * 2006-08-22 2014-03-18 International Business Machines Corporation Database entitlement
KR100910336B1 (ko) 2006-10-19 2009-07-31 신동혁 논리 프로세스 및 물리 프로세스 모델을 맵핑한 비즈니스 프로세스 모델을 관리하기 위한 시스템 및 방법
US9846846B2 (en) * 2006-11-14 2017-12-19 International Business Machines Corporation Method and system for analyzing contact studies
US8402017B2 (en) * 2006-12-08 2013-03-19 International Business Machines Corporation Method for altering database views dependent on rules
US8332922B2 (en) * 2007-08-31 2012-12-11 Microsoft Corporation Transferable restricted security tokens
US8655918B2 (en) * 2007-10-26 2014-02-18 International Business Machines Corporation System and method of transforming data for use in data analysis tools
US20090300019A1 (en) * 2008-05-30 2009-12-03 Schumberger Technology Corporation Hierarchical item level entitlement
US8099788B2 (en) * 2008-09-16 2012-01-17 Oracle International Corporation Declarative data security for a rapid application development tool component
US9753737B2 (en) 2010-02-03 2017-09-05 Oracle International Corporation Declarative attribute security using custom properties
US9183088B2 (en) * 2010-03-31 2015-11-10 Salesforce.Com, Inc. Reducing database downtime
CN102346744B (zh) 2010-07-30 2013-11-13 国际商业机器公司 用于在多租户应用系统中处理物化表的装置
US8805882B2 (en) * 2011-01-20 2014-08-12 Microsoft Corporation Programmatically enabling user access to CRM secured field instances based on secured field instance settings
US9002803B2 (en) 2011-06-07 2015-04-07 Workday, Inc. Role-based security policy for an object-oriented database system
GB2513798B (en) 2012-02-01 2021-03-03 Finjan Blue Inc A method for optimizing processing of restricted-access data
US9275112B2 (en) * 2012-11-09 2016-03-01 Microsoft Technology Licensing, Llc Filtering views with predefined query
US20140380139A1 (en) * 2013-06-21 2014-12-25 Microsoft Corporation Embedded experience through bidirectional integration of crm applications and spreadsheet applications
US20150026075A1 (en) * 2013-07-16 2015-01-22 Microsoft Corporation Control of crm data based on spreadsheet actions
US20150286487A1 (en) * 2014-04-04 2015-10-08 CafeX Communications Inc. System for monitoring and analyzing application data to proactively offer assistance
US9824227B2 (en) 2015-01-26 2017-11-21 Red Hat, Inc. Simulated control of a third-party database
US10454938B2 (en) * 2015-05-28 2019-10-22 International Business Machines Corporation Dynamic permission roles for cloud based applications
US11640544B2 (en) 2020-06-18 2023-05-02 Microsoft Technology Licensing, Llc Advances in data provisioning including bulk provisioning to aid management of domain-specific data via software data platform
US12136135B2 (en) * 2020-06-18 2024-11-05 Microsoft Technology Licensing, Llc Advances in data ingestion and data provisioning to aid management of domain-specific data via software data platform
US11704306B2 (en) 2020-11-16 2023-07-18 Snowflake Inc. Restricted views to control information access in a database system
CN115248933B (zh) 2021-04-26 2024-06-11 北京字跳网络技术有限公司 权限设置方法、装置、设备及介质

Citations (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US5751949A (en) 1995-05-23 1998-05-12 Mci Corporation Data security system and method
JP2001075854A (ja) 1999-08-31 2001-03-23 Hitachi Ltd データ管理方法、およびデータ管理システム、ならびにデータ管理プログラムを格納した記憶媒体
US20040044655A1 (en) 2002-09-04 2004-03-04 International Business Machines Corporation Row-level security in a relational database management system

Family Cites Families (7)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
GB9402935D0 (en) * 1994-02-16 1994-04-06 British Telecomm A method for controlling access to a database
US6134549A (en) * 1995-03-31 2000-10-17 Showcase Corporation Client/server computer system having personalizable and securable views of database data
JP2001003459A (ja) * 1999-06-24 2001-01-09 Sumitomo Metal Ind Ltd 構造物用管継手
US6820082B1 (en) * 2000-04-03 2004-11-16 Allegis Corporation Rule based database security system and method
US6581060B1 (en) * 2000-06-21 2003-06-17 International Business Machines Corporation System and method for RDBMS to protect records in accordance with non-RDBMS access control rules
US6516317B1 (en) * 2000-12-21 2003-02-04 Oracle Corporation Method and apparatus for facilitating compartmentalized database user management
US6976023B2 (en) * 2002-04-23 2005-12-13 International Business Machines Corporation System and method for managing application specific privileges in a content management system

Patent Citations (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US5751949A (en) 1995-05-23 1998-05-12 Mci Corporation Data security system and method
JP2001075854A (ja) 1999-08-31 2001-03-23 Hitachi Ltd データ管理方法、およびデータ管理システム、ならびにデータ管理プログラムを格納した記憶媒体
US20040044655A1 (en) 2002-09-04 2004-03-04 International Business Machines Corporation Row-level security in a relational database management system

Also Published As

Publication number Publication date
AU2005237168B2 (en) 2010-11-04
AU2005237168A2 (en) 2010-06-03
CA2526286A1 (en) 2006-06-22
CN1794232B (zh) 2010-09-29
KR20060071861A (ko) 2006-06-27
US20060136479A1 (en) 2006-06-22
CN1794232A (zh) 2006-06-28
US7562092B2 (en) 2009-07-14
AU2005237168A1 (en) 2006-07-06
JP2006179009A (ja) 2006-07-06
JP4906340B2 (ja) 2012-03-28
EP1675030A1 (en) 2006-06-28

Similar Documents

Publication Publication Date Title
KR101224822B1 (ko) Ｃｒｍ 데이터베이스에서의 보안 뷰
US11386221B2 (en) Fine-grained access control for data manipulation language (DML) operations on relational data
CN111684440B (zh) 多租户数据库系统中的安全数据共享
US7346617B2 (en) Multi-table access control
JP4398371B2 (ja) リレーショナル・データベースへのアクセスを制御する方法
US6578037B1 (en) Partitioned access control to a database
US7720863B2 (en) Security view-based, external enforcement of business application security rules
US6289344B1 (en) Context-sensitive authorization in an RDBMS
US8086615B2 (en) Security data redaction
US9607099B2 (en) Query conditions-based security
US9524308B2 (en) System and method for providing pluggable security in an enterprise crawl and search framework environment
US9002803B2 (en) Role-based security policy for an object-oriented database system
US8386448B2 (en) Methods, systems, and computer program products for providing a generic database security application using virtual private database functionality with a common security policy function
US20110313981A1 (en) Data Privacy, Redaction and Integrity for Relational Databases
US20090319527A1 (en) Method and apparatus for logging privilege use in a distributed computing environment
US20090012987A1 (en) Method and system for delivering role-appropriate policies
US20180107832A1 (en) Table privilege management
US8190673B2 (en) Enforcement of object permissions in enterprise resource planning software
US8732847B2 (en) Access control model of function privileges for enterprise-wide applications
CN108140053A (zh) 可插拔数据库锁定配置文件
WO2015005765A2 (en) Security model switching for database management system
Chandra et al. Unity Catalog: Open and Universal Governance for the Lakehouse and Beyond
US20060136361A1 (en) Extensible, customizable database-driven row-level database security
Eavis et al. OLAP authentication and authorization via query re-writing
Upadhyaya et al. Stop That Query! The Need for Managing Data Use.

Legal Events

Date Code Title Description
PA0109 Patent application

St.27 status event code: A-0-1-A10-A12-nap-PA0109

PG1501 Laying open of application

St.27 status event code: A-1-1-Q10-Q12-nap-PG1501

A201 Request for examination
AMND Amendment
E13-X000 Pre-grant limitation requested

St.27 status event code: A-2-3-E10-E13-lim-X000

P11-X000 Amendment of application requested

St.27 status event code: A-2-2-P10-P11-nap-X000

P13-X000 Application amended

St.27 status event code: A-2-2-P10-P13-nap-X000

PA0201 Request for examination

St.27 status event code: A-1-2-D10-D11-exm-PA0201

R17-X000 Change to representative recorded

St.27 status event code: A-3-3-R10-R17-oth-X000

D13-X000 Search requested

St.27 status event code: A-1-2-D10-D13-srh-X000

D14-X000 Search report completed

St.27 status event code: A-1-2-D10-D14-srh-X000

E902 Notification of reason for refusal
PE0902 Notice of grounds for rejection

St.27 status event code: A-1-2-D10-D21-exm-PE0902

AMND Amendment
P11-X000 Amendment of application requested

St.27 status event code: A-2-2-P10-P11-nap-X000

P13-X000 Application amended

St.27 status event code: A-2-2-P10-P13-nap-X000

E601 Decision to refuse application
PE0601 Decision on rejection of patent

St.27 status event code: N-2-6-B10-B15-exm-PE0601

J201 Request for trial against refusal decision
PJ0201 Trial against decision of rejection

St.27 status event code: A-3-3-V10-V11-apl-PJ0201

AMND Amendment
E13-X000 Pre-grant limitation requested

St.27 status event code: A-2-3-E10-E13-lim-X000

P11-X000 Amendment of application requested

St.27 status event code: A-2-2-P10-P11-nap-X000

P13-X000 Application amended

St.27 status event code: A-2-2-P10-P13-nap-X000

PB0901 Examination by re-examination before a trial

St.27 status event code: A-6-3-E10-E12-rex-PB0901

B701 Decision to grant
PB0701 Decision of registration after re-examination before a trial

St.27 status event code: A-3-4-F10-F13-rex-PB0701

GRNT Written decision to grant
PR0701 Registration of establishment

St.27 status event code: A-2-4-F10-F11-exm-PR0701

PR1002 Payment of registration fee

St.27 status event code: A-2-2-U10-U11-oth-PR1002

Fee payment year number: 1

PG1601 Publication of registration

St.27 status event code: A-4-4-Q10-Q13-nap-PG1601

PN2301 Change of applicant

St.27 status event code: A-5-5-R10-R13-asn-PN2301

St.27 status event code: A-5-5-R10-R11-asn-PN2301

PN2301 Change of applicant

St.27 status event code: A-5-5-R10-R11-asn-PN2301

PN2301 Change of applicant

St.27 status event code: A-5-5-R10-R14-asn-PN2301

LAPS Lapse due to unpaid annual fee
PC1903 Unpaid annual fee

St.27 status event code: A-4-4-U10-U13-oth-PC1903

Not in force date: 20160116

Payment event data comment text: Termination Category : DEFAULT_OF_REGISTRATION_FEE

PC1903 Unpaid annual fee

St.27 status event code: N-4-6-H10-H13-oth-PC1903

Ip right cessation event data comment text: Termination Category : DEFAULT_OF_REGISTRATION_FEE

Not in force date: 20160116

R18-X000 Changes to party contact information recorded

St.27 status event code: A-5-5-R10-R18-oth-X000