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 Database Administration - NCR

NCR Teradata RDBMS Database Administration - NCR , 2004. - 616 p.
Download (direct link): teradatadatabaseadmin2004.pdf
Previous << 1 .. 70 71 72 73 74 75 < 76 > 77 78 79 80 81 82 .. 218 >> Next

3 Log off as user DBC Log on again as your database administration user (SYSDBA)
4 Create a profile that defines: A profile name One or more of the following: - PASSWORD attributes - SPOOL space - TEMP space - ACCOUNT (one or more IDs, with or without Priority Group and ASE codes) - DEFAULT DATABASE
5 To assign the profile to each user in the group, use CREATE USER or MODIFY USER: MODIFY USER username AS PROFILE=profilename ; To remove a profile from a member but retain the profile itself: MODIFY USER username AS PROFILE=NULL ;

Profiles and User Defaults

Profile definitions apply to every assigned user, overriding specifications at the system or user level. However, any profile definition can be NULL or NONE.

If you do not specify one or more profile definitions, the default value for the user session is determined as follows:

5 - 10

Teradata RDBMS Database Administration Chapter 5: Setting Up Users, Profiles, Accounts and Accounting

Implementing Roles and Profiles

IF the null parameter is .

THEN the default value is taken from .

a password attribute

the system-wide specification for the corresponding attribute in the DBC.SysSecDefaults table, as explained in "Customizing Your Password Controls" on page 6-21.

all others

either:

The definitions in the CREATE USER or last MODIFY USER statement.

If none are specified, a value determined as follows:

Parameter Default Value
Account ID The default account ID of the immediate owner of the user.
Performance group Level M.
DEFAULT DATABASE Username.
SPOOL The same TEMP value as the owner of the space in which the user is being created.
TEMP The same TEMP value as the owner of the space in which the user is being created.

5 - 10 Teradata RDBMS Database Administration

Chapter 5: Setting Up Users, Profiles, Accounts and Accounting

System Accounting Functions

Defining Accounts

A session is always associated with an account. At logon time, the session is associated with the default account of the user unless the logon or startup string specifies a different account. During a session the user can submit a SET SESSION ACCOUNT statement to change to a different account, as long as:

The specified account has already been defined for that user in the most current CREATE/MODIFY USER/PROFILE statement

If a performance group is specified, it is not higher than the one already defined for that user in the current CREATE/MODIFY USER/PROFILE statement or, if none is already defined, the default level (M).

Note: For a full explanation of the capabilities and rules of setting session accounts dynamically, see "Changing the Performance Group of a Running Job" on page 5-23.)

Accounts are useful for:

Managing workloads, especially when used in conjunction with priority scheduling and TDQM

Monitoring resource usage in order to tune performance and anticipate capacity requirements

Billing purposes, particularly when a user account is associated with one or more Account String Expansion (ASE) codes, which can report session activity with a fine granularity. For a database, you can specify an account to charge for the allocated space. For a user or profile, you can specify one or more accounts to charge for the space a user occupies, or the resources used during sessions the user initiates.

You can assign or modify a user account string with a performance group name ($groupname$), and/or an ASE designation (&char), and/or an account ID. Enclose the entire string in single quotes:

'$M$&Dacctl0l'

If you assign more than one account, separate the strings with a comma and enclose the complete definition in parentheses:

('&D&Tacct4 07','acct4 07')

You can define one or more account strings at the user level or the profile level. A profile enables you to assign or change all or any part of the designation just once for many users; for example:

CREATE PROFILE tactqry AS ACCOUNT = ~$H2$&Hacctl0l' ; MODIFY USER userl,user2,user3 AS PROFILE = tactqry; MODIFY PROFILE tactqry AS ACCOUNT = ,$M2$&Hacctl0l' ;

5 - 40

Teradata RDBMS Database Administration Chapter 5: Setting Up Users, Profiles, Accounts and Accounting

System Accounting Functions

If you define more than one account at the user or profile level, the user can specify which one is to be used either at the time of logon or during the session.

Finding the Default Account

Each time a CREATE/MODIFY DATABASE statement is processed, a row is inserted or updated in the system table DBC.Accounts and in DBC.DBase. Each time a CREATE/MODIFY USER/PROFILE statement is processed, a row is inserted or updated in DBC.Accounts and in DBC.DBase and/or DBC.Profiles. The initial default account is determined as follows:

IF

THEN the default account is .

the user has a profile with one or more accounts

the first account defined in the profile.

Note: A profile account takes precedence over the user account.
Previous << 1 .. 70 71 72 73 74 75 < 76 > 77 78 79 80 81 82 .. 218 >> Next