HP Vertica

Menu

  • Home
  • Palukuru
  • SQL Server
  • SSIS
  • SSRS
  • HP Vertica
  • Devalayalu
  • Recipes
  • Telugu Stories

Monday, 20 October 2014

HP Vertica



DB User:
  • User Creation
  • GRANT USAGE ON SCHEMA PUBLIC
  • Create Schema
  • Grant usage privileges on a schema to the user
  • Grant all privileges on a schema to the user
  • Set default search path
  • Change Vertica User Privileges from Existing User to New user
  • Execute Permissions on User Defined Functions For New Users
  • Grant Execute Permissions on ODBC

Vertica Table
  • Creation
  • Rename Table, Table Column Or View in Vertica
  • Projection Creation
  • Create A New Table Using Existing Table
  • Create Table Partitions
  • Change the Owner of Table
  • Drop Partition

Sequence:
  • Create Sequence Number
  • Alter Sequence
  • Drop Sequence
  • Add Sequence Or Set Default value to a table
  • Drop Default Or Sequence on a Table
  • Change the Owner of Sequence

Vertica Sessions
  • Close Session in Vertica
  • Currently Running Sessions in Vertica




Posted by Kiran Y at 06:22
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest

No comments:

Post a Comment

Newer Post Older Post Home
Subscribe to: Post Comments (Atom)

Blog Archive

  • ►  2017 (2)
    • ►  August (2)
  • ►  2015 (16)
    • ►  December (7)
    • ►  November (7)
    • ►  May (1)
    • ►  April (1)
  • ▼  2014 (26)
    • ▼  October (2)
      • isnumeric function
      • HP Vertica
    • ►  April (8)
    • ►  February (16)

About Me

Kiran Y
View my complete profile
Simple theme. Theme images by luoman. Powered by Blogger.