Langsung ke konten utama

Postingan

Menampilkan postingan dengan label CREATE USER

NETEZZA - CREATE USER command to create a new user account

 https://dwgeek.com/netezza-create-user-command-examples.html/ CREATE USER Use the CREATE USER command to create a new user account. Syntax Syntax for creating a user: CREATE USER <username> [WITH <clause> [<clause>…] ] Where  <clause>  represents one of: PASSWORD {'<pw>'| NULL } | EXPIRE PASSWORD PASSWORDEXPIRY <days> AUTH {LOCAL| DEFAULT } SYSID <userid> | IN GROUP <usergrp>[,<usergrp>…] | IN RESOURCEGROUP <rsg> VALID UNTIL '<valid_date>' | DEFPRIORITY {CRITICAL|HIGH|NORMAL|LOW| NONE } | MAXPRIORITY {CRITICAL|HIGH|NORMAL|LOW| NONE } | ROWSETLIMIT <rslimit> | SESSIONTIMEOUT <sessiontimeout> | QUERYTIMEOUT <querytimeout> | CONCURRENT SESSIONS <concsessions> | SECURITY LABEL {'<seclabel>| PUBLIC:: '} | AUDIT CATEGORY { NONE |'<category>[,<category>…]'} COLLECT HISTORY {ON|OFF| DEFAULT } | ALLOW CROSS JOIN {TRUE|FALSE|NULL} | ACCESS TIME { ALL |DEFA...