GRANT CONNECT statement

Creates a new user, and can also be used by a user to change their own password.

It is recommended that you use the CREATE USER statement to create users instead of the GRANT CONNECT statement.

GRANT CONNECT TO userid, ...
[ AT starting-id ]
[ IDENTIFIED BY password, ... ]

CONNECT TO clause Creates a new user. GRANT CONNECT can also be used by any user to change their own password. To create a user with an empty string as the password, use:
GRANT CONNECT TO userid IDENTIFIED BY "";
To create a user with no password, use:
GRANT CONNECT TO userid;
A user with no password cannot connect to the database. This is useful if you are creating a group and do not want anyone to connect to the database using the group user ID.

The verify_password_function option can be used to specify a function to implement password rules (for example, passwords must include at least one digit). If a password verification function is used, you cannot specify more than one user ID and password in the GRANT CONNECT statement.
AT clause This clause is for internal use by the Unload utility.

Discuter à propos de cette page dans DocCommentXchange.