Owner Concept

      +
      Understand object ownership in Enterprise Analytics and how owners automatically receive privileges to manage their objects.

      Enterprise Analytics uses the concept of an OWNER to manage object ownership and associated privileges. An OWNER is a user who creates an object in the system, such as a database, collection, view, function, or other entities.

      When a user creates an object, the user is granted the OWNERSHIP privilege implicitly. This information is stored in the Metadata.Privilege collection.

      Implicit Privileges

      The following table shows the implicit privileges granted to owners for each object type:

      Table 1. Implicit Privileges
      Object Type Implicit Privileges

      Database

      DROP

      Scope

      DROP

      Collection

      SELECT, INSERT, UPSERT, DELETE, ALTER, DROP, ANALYZE

      Index

      DROP

      Link

      CONNECT, DISCONNECT, COPY TO, COPY FROM, DROP, ALTER

      Role

      DROP

      Synonym

      DROP

      Function

      DROP, EXECUTE

      View

      SELECT, DROP