Please use the form below to provide your feedback. Because your feedback is valuable to us, the information you submit in this form is recorded in our issue tracking system (JIRA), which is publicly available. You can track the status of your feedback using the ticket number displayed in the dialog once you submit the form.

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