Allows the user to connect to the Oracle Server with SYSOPER or SYSDBA system privileges.
O90 Oracle9i
O10 Oracle 10g
ConnectAs = 'value'
Parameter |
Description |
|---|---|
value |
Values are:
|
Normal
If ConnectAs ='Normal',
this parameter is not used. If ConnectAs ='SYSDBA' or ConnectAs ='SYSOPER',
Oracle9i or later allows the user to connect
with SYSDBA or SYSOPER privileges,
respectively, provided that these privileges have been granted the
user.
If you connect using ConnectAs ='SYSDBA',
Oracle9i or later uses the SYS schema
instead of the schema that might already be associated with the
user ID. If you connect using ConnectAs ='SYSOPER',
Oracle9i or later uses the PUBLIC schema.
Do not use with CnnPool = 'Yes'
Connection pooling cannot be used with this parameter. Do
not select Use Connection Pool in the Database Profile Setup dialog
box or set CnnPool to 'Yes'.
To use the SYS schema instead of the schema associated with the User ID:
Database profile Select SYSDBA from the Connect As drop-down list on the Connection page in the Database Profile Setup dialog box, and make sure Use Connection Pool is deselected.
Application Type the following in code:
SQLCA.DBParm = "ConnectAs='SYSDBA'"
