Langsung ke konten utama

Netezza Alter User Command and Examples

https://dwgeek.com/netezza-alter-user-command-examples.html/

Once you created a user, you can change the parameters of the user at any time with Netezza ALTER USER command. You can read my other post Netezza CREATE USER command and examples.

Netezza Alter User Command Syntax

In the Netezza, username, database name and group name are unique. You cannot have same user as the group name.

Read:

Syntax for altering a user:

ALTER USER username
[WITH
[PASSWORD {'string' | NULL }]
[SYSID uid]
[ROWSETLIMIT [integer ]
[IN GROUP groupname [, ...] ]
[VALID UNTIL 'date' ]
[SESSIONTIMEOUT [integer ]
[QUERYTIMEOUT [integer ]
[DEFPRIORITY [critical|high|normal|low|none]]
[MAXPRIORITY [critical|high|normal|low|none]]
[IN RESOURCEGROUP resourcegroupname]
[EXPIRE PASSWORD]
]
| CONCURRENT SESSIONS <limit>
| ALLOW CROSS JOIN [TRUE|FALSE|NULL]

Netezza Alter User Command Options

The alter user command takes following inputs. Below are the some of the important options associated with the Netezza alter user command:

OptionDescription
usernameSpecifies the name of the user you are creating
stringSpecifies a password for this user account
NULLYou can specify WITH PASSWORD NULL to explicitly create a user

with a null password

dateSpecifies the date when this user’s

account expires

SESSIONTIMEOUTSpecifies the amount of time a session can be idle before the system

terminates it. The value zero is unlimited

QUERYTIMEOUTSpecifies the amount of time a query can run before the system

sends the administrator a message.

DEFPRIORITYSpecifies the default priority for the user. critical, high, normal, low
IN RESOURCEGROUPSpecifies the resource group into which to add a user
IN GROUPSpecifies the group into which to insert the user as a new member. e.g Developer, Administrator etc
CONCURRENT SESSIONS <limit>Sets the maximum number of concurrent sessions this group can have

Netezza Alter User Command Examples

Below are some examples on how to alter user:

TRAINING.ADMIN(ADMIN)=> ALTER USER testuser1 WITH PASSWORD 'test123' VALID UNTIL '2017-05-15'; 
ALTER USER 
TRAINING.ADMIN(ADMIN)=>

[nz@netezza ~]$ nzsql -u testuser1 -pw test123; 
Welcome to nzsql, the IBM Netezza SQL interactive terminal. 
Type: \h for help with SQL commands 
 \? for help on internal slash commands 
 \g or terminate with semicolon to execute query 
 \q to quit

SYSTEM.ADMIN(TESTUSER1)=>

Netezza Alter User Command – RESET, RENAME

You can also use the Netezza alter user command to RESET user account and also to rename user.

ALTER USER user_name OWNER TO username 
ALTER USER user_name RESET ACCOUNT 
ALTER USER user_name RENAME TO newname
Label:

Komentar

Posting Komentar

Silakan dikomen...

Postingan populer dari blog ini

CREATE CROSS TAB QUERY IN MYSQL

MySQL Multi-Aggregated Rows in Crosstab Queries MySQL’s crosstabs contain aggregate functions on two or more fields, presented in a tabular format. In a multi-aggregate crosstab query, two different functions can be applied to the same field or the same function can be applied to multiple fields on the same (row or column) axis. Rob Gravelle shows you how to apply two different functions to the same field in order to create grouping levels in the row axis. Today’s topic of discussion is crosstabs, which contain multiple aggregate functions in the row axis of a tabular resultset. Recall from the the  All About the Crosstab Query  article that an aggregate function is one that summarizes a group of related data in some way. Examples of aggregate functions include COUNT, SUM, AVG, MIN, and MAX. In a multi-aggregate crosstab query, two different functions can be applied to the same field or the same function can be applied to two or more fields. Today we’ll create a query...
Posting Komentar
Baca selengkapnya

Mysql Import data from CSV File

  Microsoft Windows [Version 10.0.15063] (c) 2017 Microsoft Corporation. All rights reserved. C:\Users\PSI011>cd C:\xampp\mysql\bin C:\xampp\mysql\bin> mysqld 2017-08-22 14:24:49 15428 [Note] mysqld (mysqld 10.1.25-MariaDB) starting as process 16352 ... C:\xampp\mysql\bin> mysql -u root -p Enter password: Welcome to the MariaDB monitor. Commands end with ; or \g. Your MariaDB connection id is 9 Server version: 10.1.25-MariaDB mariadb.org binary distribution Copyright (c) 2000, 2017, Oracle, MariaDB Corporation Ab and others. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. MariaDB [(none)]> use pkh; Database changed MariaDB [pkh]> LOAD DATA LOCAL INFILE 'D:/2017/PKH_FOR_BPKP/PKH_FOR_BPKP_01.csv' -> INTO TABLE pkh_bpkp -> FIELDS TERMINATED BY ',' -> OPTIONALLY ENCLOSED BY '"' -> ESCAPED BY '"' -> LINES TERMINATED BY '\n...
Posting Komentar
Baca selengkapnya

Pentaho Data Integration: Membuat Koneksi ke database MSSQL Server 2008 R2

Untuk terhubung ke database SQL Server langkah-langkah berikut harus dilakukan:   Download Driver Microsoft JDBC di https://www.microsoft.com/en-us/download/details.aspx?displaylang=en&id=11774  Tutup Spoon atau Kettle project  Unzip/extract paket dalam direktori temporer (bebas) Copy '<temp directory> \ sqljdbc_6.0\enu\auth\x64\ sqljdbc_auth.dll' ke 'C:\Program Files\Java\jre1.8.0_131' atau sesuaikan dengan path java runtime terinstall  Copy '<temp directory>\ sqljdbc_6.0\enu\jre8\sqljdbc42.jar' ke '<Kettle folder instalasi> \ data-integration \ lib' Buka Spoon atau Kettle project Uji koneksi dalam Spoon Hapus direktori temporer karena sudah tidak digunakan lagi Jika kita meng-upgrade Kettle, Java, JDBC Driver ke versi yang lebih tinggi, maka serangkaian langkah-langkah di atas harus diulang lagi.
2 komentar
Baca selengkapnya