Privileges for Executing the CONNECT Statement

The current user, or PUBLIC, must hold the Connect privilege on the database that the CONNECT statement specifies. The user who executes the CONNECT statement cannot have the same authorization identifier as an existing role in that database.

For information on how to use the USER Authentication clause to specify an alternate user name when the CONNECT statement connects to a database server on a remote host, see USER Authentication Clause.