ROW-LEVEL SECURITY
    3.
    发明申请

    公开(公告)号:US20230022027A1

    公开(公告)日:2023-01-26

    申请号:US17936681

    申请日:2022-09-29

    申请人: Snowflake Inc.

    IPC分类号: G06F21/62 G06F21/60 G06F16/22

    摘要: 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.

    SYSTEM FOR IMPLEMENTING AN OBJECT SHARING FRAMEWORK

    公开(公告)号:US20220197912A1

    公开(公告)日:2022-06-23

    申请号:US17689463

    申请日:2022-03-08

    申请人: Snowflake Inc.

    摘要: 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.

    SYSTEM FOR IMPLEMENTING AN OBJECT TAGGING FRAMEWORK

    公开(公告)号:US20220138206A1

    公开(公告)日:2022-05-05

    申请号:US17102156

    申请日:2020-11-23

    申请人: Snowflake Inc.

    摘要: 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.

    Account-level namespaces for database platforms

    公开(公告)号:US11249988B2

    公开(公告)日:2022-02-15

    申请号:US16945344

    申请日:2020-07-31

    申请人: Snowflake Inc.

    摘要: 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.

    Namespace-based system-user access of database platforms

    公开(公告)号:US11593354B2

    公开(公告)日:2023-02-28

    申请号:US16945546

    申请日:2020-07-31

    申请人: Snowflake Inc.

    摘要: 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.