Books
in black and white
Main menu
Share a book About us Home
Books
Biology Business Chemistry Computers Culture Economics Fiction Games Guide History Management Mathematical Medicine Mental Fitnes Physics Psychology Scince Sport Technics
Ads

Teradata RDBMS forUNIX SQL Reference - NCR

NCR Teradata RDBMS forUNIX SQL Reference - NCR, 1997. - 913 p.
Download (direct link): teradataforunix1997.pdf
Previous << 1 .. 133 134 135 136 137 138 < 139 > 140 141 142 143 144 145 .. 241 >> Next

DEFAULT JOURNAL TABLE = dbname.tname Identifies the default table that is to receive the journal images of data tables created in the new database. tname must be defined if journaling is requested, but it need not reside in the new database. tname is automatically created in the new database if dbname is not specified, or the new database is specified. If a different database is specified, then that database must exist and tname must have been defined as its default journal table.
An option may only be specified once the PERMANENT or PERM option and the PASSWORD options are specified. The combined total number of databases and users for any one system is limited to 32,767.

Teradata RDBMS for UNIX SQL Reference

8-99
Teradata SQL Syntax Guide

CREATE USER

Required Privileges

To create a user, the creator must have CREATE USER privilege on the immediate owner database. The creator receives all privileges on the newly created user:

• Create Database

• Create Macro

• Checkpoint

• Create Table

• Create User

• Create View

• Delete

• Drop Database

• Drop Macro

• Drop Table

• Drop User

• Drop View

• Dump

• Execute

• Insert

• Revoke

• Restore

• Update.

Privileges given to the creator and owner are WITH GRANT OPTION.

The newly created user also receives all relevant privileges on itself, namely:

• Create Macro

• Checkpoint

• Create Table

• Create View

• Delete

• Drop Macro

• Drop Table

• Drop View

• Dump

• Execute

• Insert

• Revoke

• Restore

• Update.

8-100

Teradata RDBMS for UNIX SQL Reference
Teradata SQL Syntax Guide

CREATE USER

Privileges given to the new user are not WITH GRANT OPTION.

The newly created user is automatically granted the privileges needed to create and maintain objects in his or her space, but must be explicitly granted the privileges needed to CREATE USER/MODIFY USER or CREATE DATABASE (see also the “GRANT” statement). The privileges automatically granted are:

The acctid may include an optional priority-level prefix. User priorities are used to maintain efficient operation of the Teradata RDBMS while providing equitable service to multiple client systems and users. Any user who has the CREATE/MODIFY USER privilege may assign a priority; therefore, the Teradata RDBMS administrator should monitor priority assignments closely.

The COLLATION option determines the ordering of data characters during comparison operations and when sorting data in response to a SELECT query that includes an ORDER BY or WITH...BY clause.

If the COLLATION option is not given the default is HOST.

During any session, the user can override the COLLATION attribute by executing a SET SESSION COLLATION statement.

The MULTINATIONAL parameter defines the default collation Multinational sequence for the user to be one of the International sort orders (see

the ORDER BY clause of the “SELECT” statement).

The MULTINATIONAL parameter determines that the International sort order is to be used (see the ORDER BY clause of the SELECT statement in Chapter 7). This parameter returns an error unless the hashing algorithm of the Teradata RDBMS is set to recognize diacritical characters.

On International/European sites MULTINATIONAL collation is two level. On Japanese sites, it is one level. It is always available.

The user may specify an acctid at logon time by including an acctid Acctids Can Be Specified in the logon string. The acctid specified at logon must be one of the

During Logon acctid’s defined for the user.

If not specified in the logon string, the default is the first (or only) acctid defined in the most recent CREATE/MODIFY USER statement for the user. If not specified in a CREATE/MODIFY USER statement, the default is the acctid of the user’s immediate owner database.

CPU and I/O resources expended by a session are charged to the account specified (or implied) at logon time.

Teradata RDBMS for UNIX SQL Reference

8-101
Teradata SQL Syntax Guide

CREATE USER

Reporting Space Used by User

PERM/SPOOL Space

USING Modifier in STARTUP String

LOCAL JOURNALING

Example

All space (permanent and spool) used by the user is reported in the Teradata views under the acctid specified at logon (or the default acctid, if not specified at logon).

If necessary, the defined PERM or SPOOL space is changed to the next higher value that is a multiple of the number of AMPs on the system. If no SPOOL space is defined, the space assigned is the largest value that is not greater then the owner’s spool space and that is a multiple of the number of AMPs on the system.

The USING modifier is not supported in a STARTUP string. If it is specified, no error is indicated when the CREATE USER statement is processed, and the USING clause is stored. However, when the string is invoked, a message is returned that a “Data or IndicData parcel” is not found or is not allowed.
Previous << 1 .. 133 134 135 136 137 138 < 139 > 140 141 142 143 144 145 .. 241 >> Next