HP Big Data Quick Start Guide download pdf (Page 18)

Performing common database administrator tasks

This section describes some of the common tasks the HP Vertica database administrator performs.

This section assumes that you are familiar with the basic concepts and terminology of relational

database management systems and SQL. For more information, see the HP Vertica Administrator’s

Guide.

Creating a database

HP Vertica provides two options to create a database: Management Console or the Administration

Tools. See Create an Empty Database in the HP Vertica Administrator’s Guide.

Rules for database and password names

When you create a database, one of your first tasks is to name the database and supply a secure

password. See Creating a Database Name and Password in the HP Vertica Administrator’s Guide.

Starting and stopping the database

You can start and stop your database using the Administration Tools, Management Console or

from the command line. For details, see the following topics in the HP Vertica Administrator’s

Guide:

• Starting the Database

• Stopping the Database

Reconnecting to the database

• If you close your terminal window while the database is running, you can reconnect as follows:

Open a remote session to reconnect to HP Vertica, see “Connecting to HP Vertica using

a remote terminal client” (page 13).

2. Log in as the dbadmin user.

3. Type admintools at the command line.

4. Select Connect to Database from the Main Menu and click OK.

• If you close your browser window while the database is running, follow the steps in “Connecting

to HP Vertica using the browser-based Management Console” (page 14)

See Using the Administration Tools in the HP Vertica Administrator’s Guide.

Implementing security

In HP Vertica, there are three primary security concerns:

• Client authentication prevents unauthorized access to the database.

• Client authorization controls what users can access and change in the database.

• Connection encryption prevents the interception of data and authenticates the identity of the

server and the client.

See Implementing Security in the HP Vertica Administrator’s Guide.

Creating new database users

Client authentication controls which database objects users can access and change in the database.

To prevent unauthorized access, a superuser limits access by assigning privileges directly to users

or to roles through a series of GRANT statements.

A Management Console administrator can also grant MC users access to one or more HP Vertica

databases through the MC interface.

See Managing Users and Privileges in the HP Vertica Administrator’s Guide.

18 Using HP Vertica

1 2 ... 13 14 15 16 17 18 19 20 21 22 23 24

No comments

HP Big Data Quick Start Guide Page 18