-
公开(公告)号:US11727139B2
公开(公告)日:2023-08-15
申请号:US17936681
申请日:2022-09-29
申请人: Snowflake Inc.
发明人: Artin Avanes , Khalid Zaman Bijon , Zheng Mi , Subramanian Muralidhar , David Schultz , Jian Xu
CPC分类号: G06F21/6227 , G06F16/2282 , G06F21/604 , G06F21/62 , G06F21/6218 , G06F2221/2141
摘要: Row-level security (RLS) may provide fine-grained access control based on flexible, user-defined access policies to databases, tables, objects, and other data structures. A RLS policy may be an entity or object that defines rules for row access. A RLS policy may be decoupled or independent from any specific table. This allows more robust and flexible control. A RLS policy may then be attached to one or more tables. The RLS policy may include a Boolean-valued expression.
-
公开(公告)号:US20230102349A1
公开(公告)日:2023-03-30
申请号:US18062656
申请日:2022-12-07
申请人: Snowflake Inc.
发明人: Artin Avanes , Khalid Zaman Bijon , Damien Carru , Thierry Cruanes , Vikas Jain , Zheng Mi , Subramanian Muralidhar
IPC分类号: G06F21/62 , G06F16/22 , G06F16/27 , G06F16/25 , G06F16/248
摘要: A shared database platform implements dynamic masking on data shared between users where specific data is masked, transformed, or otherwise modified based on preconfigured functions that are associated with user roles. The shared database platform can implement the masking at runtime dynamically in response to users requesting access to a database object that is associated with one or more masking policies.
-
公开(公告)号:US20230022027A1
公开(公告)日:2023-01-26
申请号:US17936681
申请日:2022-09-29
申请人: Snowflake Inc.
发明人: Artin Avanes , Khalid Zaman Bijon , Zheng Mi , Subramanian Muralidhar , David Schultz , Jian Xu
摘要: Row-level security (RLS) may provide fine-grained access control based on flexible, user-defined access policies to databases, tables, objects, and other data structures. A RLS policy may be an entity or object that defines rules for row access. A RLS policy may be decoupled or independent from any specific table. This allows more robust and flexible control. A RLS policy may then be attached to one or more tables. The RLS policy may include a Boolean-valued expression.
-
公开(公告)号:US20220197912A1
公开(公告)日:2022-06-23
申请号:US17689463
申请日:2022-03-08
申请人: Snowflake Inc.
发明人: Artin Avanes , Khalid Zaman Bijon , Yujie Li , Zheng Mi , Subramanian Muralidhar , David Schultz
IPC分类号: G06F16/2457 , G06F16/27 , G06F16/28 , G06F16/21 , G06F16/23
摘要: A method of implementing object tagging framework starts with the processor receiving a tag creation command including a tag name. In response to the tag creation command, the processor creates a current tag. The processor then receives an association command, the tag name and a source object identifier. The processor determines a source object associated with the source object identifier. The source object includes a tag value. The processor associates the current tag with the source object. The processor receives a replication command including the source object and a target object. The processor causes replication of the source object to the target object that comprises replicating the current tag with the tag name and the tag value in the source object to the target object. Other embodiments are also described herein.
-
公开(公告)号:US20220138206A1
公开(公告)日:2022-05-05
申请号:US17102156
申请日:2020-11-23
申请人: Snowflake Inc.
发明人: Artin Avanes , Khalid Zaman Bijon , Yujie Li , Zheng Mi , Subramanian Muralidhar , David Schultz
IPC分类号: G06F16/2457 , G06F16/28 , G06F16/22 , G06F16/21
摘要: A method of implementing object tagging framework starts with the processor receiving a tag creation command including a tag name. In response to the tag creation command, the processor creates a current tag. The processor then receives an association command, the tag name and a target object identifier. The processor determines a target object associated with the target object identifier. The target object includes a tag value. The processor associates the current tag with the target object. The processor identifies a first child object of the target object. The target object and the first child object are hierarchical objects. In response to determining that the first child object is tag-unassociated, the processor associates the current tag with the first child object. In response to receiving a query including the tag name, the processor generates an output based on the tag name. Other embodiments are also described herein.
-
公开(公告)号:US11249988B2
公开(公告)日:2022-02-15
申请号:US16945344
申请日:2020-07-31
申请人: Snowflake Inc.
发明人: Damien Carru , Thierry Cruanes , Istvan Cseri , Benoit Dageville , Zheng Mi , Subramanian Muralidhar
IPC分类号: G06F16/23 , G06F16/27 , G06F16/9535 , G06Q30/00
摘要: A database platform receives an object identifier from a client in association with a database session. The client is associated with a customer account of the database platform, and the database session is associated with the client. In response to receiving the object identifier, the database platform identifies a resolution namespace for the object identifier, where the resolution namespace for the object identifier is a namespace that is specified in the object identifier if the object identifier includes a specified namespace, and where the resolution namespace is otherwise a current account-level namespace of the database session. The database platform resolves the object identifier with reference to the identified resolution namespace for the object identifier, including identifying an object corresponding to the object identifier in the customer account.
-
公开(公告)号:US11055430B2
公开(公告)日:2021-07-06
申请号:US17086269
申请日:2020-10-30
申请人: Snowflake Inc.
发明人: Artin Avanes , Khalid Zaman Bijon , Damien Carru , Thierry Cruanes , Vikas Jain , Zheng Mi , Subramanian Muralidhar
IPC分类号: G06F21/62 , G06F16/27 , G06F16/25 , G06F16/22 , G06F16/248
摘要: A shared database platform implements dynamic masking on data shared between users where specific data is masked, transformed, or otherwise modified based on preconfigured functions that are associated with user roles. The shared database platform can implement the masking at runtime dynamically in response to users requesting access to a database object that is associated with one or more masking policies.
-
公开(公告)号:US20210157948A1
公开(公告)日:2021-05-27
申请号:US17086269
申请日:2020-10-30
申请人: Snowflake Inc.
发明人: Artin Avanes , Khalid Zaman Bijon , Damien Carru , Thierry Cruanes , Vikas Jain , Zheng Mi , Subramanian Muralidhar
IPC分类号: G06F21/62 , G06F16/27 , G06F16/248 , G06F16/22 , G06F16/25
摘要: A shared database platform implements dynamic masking on data shared between users where specific data is masked, transformed, or otherwise modified based on preconfigured functions that are associated with user roles. The shared database platform can implement the masking at runtime dynamically in response to users requesting access to a database object that is associated with one or more masking policies.
-
公开(公告)号:US12061717B2
公开(公告)日:2024-08-13
申请号:US18062656
申请日:2022-12-07
申请人: Snowflake Inc.
发明人: Artin Avanes , Khalid Zaman Bijon , Damien Carru , Thierry Cruanes , Vikas Jain , Zheng Mi , Subramanian Muralidhar
CPC分类号: G06F21/6227 , G06F16/221 , G06F16/2282 , G06F16/248 , G06F16/252 , G06F16/27
摘要: A shared database platform implements dynamic masking on data shared between users where specific data is masked, transformed, or otherwise modified based on preconfigured functions that are associated with user roles. The shared database platform can implement the masking at runtime dynamically in response to users requesting access to a database object that is associated with one or more masking policies.
-
公开(公告)号:US11593354B2
公开(公告)日:2023-02-28
申请号:US16945546
申请日:2020-07-31
申请人: Snowflake Inc.
发明人: Damien Carru , Thierry Cruanes , Istvan Cseri , Benoit Dageville , Zheng Mi , Subramanian Muralidhar
IPC分类号: G06F16/23 , G06F16/9535 , G06F16/27 , G06Q30/00 , G06Q30/01
摘要: A database platform authenticates a system user for access via an application to a database that is associated with a customer account of the database platform. The system user is a first object in a first account-level namespace of the customer account, and the first account-level namespace is distinct from a default account-level namespace of the customer account. The database platform sends, as the system user, a query to the database via the application. The database platform receives, as the system user, results of the query from the database, and stores, as the system user, the results of the query in a first-namespace stage, which is a second object in the first account-level namespace.
-
-
-
-
-
-
-
-
-