公开(公告)号：US20180107832A1

公开(公告)日：2018-04-19

申请号：US15294297

申请日：2016-10-14

Applicant: SAP SE

Inventor： Frank Ouyang ,  Jian Wang ,  Zhen Tian

IPC: G06F21/62 ,  G06F17/30

CPC classification number: G06F16/21 ,  G06F21/6227

Abstract: Various examples are directed to systems and methods for table privilege management. A database management system (DBMS) may receive a first client request describing a first database operation on a first record from a first table of a database. The DBMS may determine that a user associated with the first client request lacks privileges to perform the first database operation on record fields in a first column of the table. The DBMS may generate a modified first database operation that does not perform the first operation on a first record field of the first record that is in the first column and may execute the modified first database operation at the database.

公开(公告)号：US10545984B2

公开(公告)日：2020-01-28

申请号：US15602373

申请日：2017-05-23

Applicant: SAP SE

Inventor： Sen Zhang ,  Yinghua Ouyang ,  Jian Wang ,  Zhen Tian

IPC: G06F17/30 ,  G06F16/25 ,  G06F16/22 ,  G06F16/21 ,  G06F16/23

Abstract: Methods, systems, and computer-readable storage media for providing a table in a database system, the table including a column having a column data type set to an abstract data type, receiving a first data record to be added to the table, the first data record including a first data value to be included in the column, determining a first data type corresponding to a data type of the first data value, changing the column data type from the abstract data type to the first data type, receiving a second data record to be added to the table, the second data record including a second data value to be including in the column, determining a second data type corresponding to the data type of the second data value, and selectively changing the column data type to the second data type.

公开(公告)号：US20180341689A1

公开(公告)日：2018-11-29

申请号：US15602373

申请日：2017-05-23

Applicant: SAP SE

Inventor： Sen Zhang ,  Yinghua Ouyang ,  Jian Wang ,  Zhen Tian

IPC: G06F17/30

CPC classification number: G06F16/258 ,  G06F16/214 ,  G06F16/221 ,  G06F16/235 ,  G06F16/2393

Abstract: Methods, systems, and computer-readable storage media for providing a table in a database system, the table including a column having a column data type set to an abstract data type, receiving a first data record to be added to the table, the first data record including a first data value to be included in the column, determining a first data type corresponding to a data type of the first data value, changing the column data type from the abstract data type to the first data type, receiving a second data record to be added to the table, the second data record including a second data value to be including in the column, determining a second data type corresponding to the data type of the second data value, and selectively changing the column data type to the second data type.