Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  • Schemas级别

    操作所需权限
    create schemacreate on database databaseName
    drop schema schema的创建者
    alter schema create on database databaseName


  • Tables级别

    操作所需权限
    create tablecreate on schema schemaName
    drop table create on schema schemaName 或 usage on schema schemaName 或是 schema的创建者 或是表的创建者
    truncate table usage on schema schemaName 或是 schema的创建者
    alter table add/drop/rename/alter-type columnusage on schema schemaName
    alter table add/drop constraintusage on schema schemaName
    alter table partition (reorganize) usage on schema schemaName
    alter table rename usage/create privileges on the schema that contains the table
    alter table ... set schema create on new schema AND usage on old schema
    select usage on schema AND select on table 
    insert usage on schema AND insert on table 
    deleteusage on schema AND DELETE/SELECT on table
    updateusage on schema AND UPDATE/SELECT on table
    REFERENCESusage on schema AND REFERENCES to create foreign key constraints that reference this table

    analyze_statistics

    analyze_statistics_partition

    usage on schema AND INSERT | DELETE | UPDATE  on table 
    drop_statisticsusage on schema AND INSERT | DELETE | UPDATE  on table 
    drop_partitionsusage on schema 


  • Views级别

    操作所需权限
    create viewcreate on schema AND select on BaseObjects
    drop view usage on schema And owner of view
    select

    view owner must have select ... with grant options 

    usage on schema 

    select on view 


  • Projections级别

    操作所需权限
    create projectionselect on theTable AND  [  usage and create on schema  | schema owner ]
    auto / delayed projectionselect on theTable AND usage on schema
    alter projection

    usage AND create on schema

    drop projectionusage on schema Or owner


  • External Procedures级别

    操作所需权限
    create proceduresuperuser
    drop proceduresuperuser
    executeusage on schema AND execute on procedure


  • Libraries级别UDF = Scalar
    UDT = Transform
    UDAnF= Analytic
    UDAF = Aggregate


  • 操作所需权限
    create librarysuperuser
    drop librarysuperuser


  • User-Defined Functions级别
    UDF = Scalar
    UDT = Transform
    UDAnF= Analytic
    UDAF = Aggregate

    操作所需权限

    create function(SQL)
    create function(scalar)
    create transform function
    create analytic function(UDFnF)
    create aggregate function(UDAF)

    create on schema 

    AND

    usage on baseLibrary

    drop function
    drop transform function
    drop analytic function
    drop aggregate function

    usage on schema

    AND

    owner of function

    alter function(scalar) ... rename to usgae And Create on schema
    alter function(scalar) ... set schema

    usage on old schame 

    AND

    create on new schema

    execute(SQL/UDF/UDT/ADAF/UDAnF) functionusage on schema AND execute on function


  • Sequences级别

    操作所需权限
    create sequencecreate on schema
    drop sequenceusage on schema Or owner
    alter sequence usgae AND create on schema 
    alter sequence ... set schemausage on old schema AND create on new schema 
    currval / nextvalusage on schema AND select on sequence


  • Resource Pools级别

    操作所需权限
    create resource pool superuser
    alter resource pool 

    superuser:
    can modify these : MAXMEMORYSIZE PRIORITY QUEUETIMEOUT

    normal-user:
    update on resource pool ( can modify these : PLANNEDCONCURRENCY SINGLEINITIATOR MAXCONCURRENCY)

    set session resource poolusage on resource_pool and  user can change their own resource pool 
    drop resource poolsuperuser


  • Users/Profiles/Roles级别

    操作所需权限
    create user/profile/rolesuperuser
    alter user/profile/rolesuperuser
    drop user/profile/rolesuperuser


  • Object Visibility级别

    操作所需权限
    look up schemaAt least one  privilege on schema
    look up object in schema or in system tables 

    usgae on schema 

    AND

    at least on privilege on any of the following objects : table/view/function/procedure/sequence

    look up projectionat least on privilege on All anchor tables And usage on the schema of all anchor tables
    look up resource pool select on resource pool
    existence of object usage on schema 


  • I/O Operations级别

    操作所需权限
    connect to verticadisconnectnone
    export to verticaselect on source table 
    usage on source schema 
    insert on destination table
    usage on destination schema
    copy from verticausage on source/destination schema
    select on source table
    insert on destination table
    copy from filesuperuser
    copy from STDIN

    usage on schema 
    insert on table

    copy local

    usage on schema 
    insert on table


  • Comments级别

    操作所需权限

    comment on {one of } :

    AGGREGATE FUNCTION
    ANALYTIC FUNCTION
    CONSTRAINT
    FUNCTION
    LIBRARY
    NODE
    PROJECTION
    PROJECTION COLUMN
    SCHEMA
    SEQUENCE
    TABLE
    TABLE COLUMN
    TRANSFORM FUNCTION
    VIEW

    object owner or superuser


  • Tuning Operations级别

    操作所需权限
    profileSame privileges required to run the query being profiled
    explainSame privileges required to run the query for which you use the EXPLAIN keyword


...