Logging on as sysdba

[Eric Allen]

Is there a way to log on as sysdba? The Oracle Enterprise tools do this, and I'd like to as well.
Also, for some functions when the o7_dictionary_accessibility parameter is false you need to be logged in as sysdba to do things like grant select to sys schema tables. Any thoughts?
TIA!

 

[Marco Kalter]

This is not yet possible on Net8. This is in fact an enhancement request for the next release.

------------------
Marco Kalter
Allround Automations

 

[mridley]

To get SYS grants, for a windows based App, try this:
- Have all your grants in a .SQL file.
- In Delphi code, Open up SQLPLUS in DOS, connecting as
'sysusername/syspassword@db as sysdba', then get SQLPUS to run the .SQL file with your grants.

 

[Eric Allen]

We actually did this by modifying DOA-there's a parameter to oci login that controls the login type. We added an enumerated type to control the login type and added it to tOracleSession.

 

[Marco Kalter]

There is a OracleSession.ConnectAs property which you can set to caSYSDBA. The TOracleLogon dialog also supports this if ldConnectAs is included in the Options property.

------------------
Marco Kalter
Allround Automations

 

[Eric Allen]

That's the one. At the time we had an older version of DOA & were unable to upgrade. We have done so, and are now using the standard property.

 

[mridley]

Upon actually trying out the SQLPLUS from DOS way, found that cannot connect 'as SYSDBA' from DOS. Probably makes sense from a security standpoint.

 

[mridley]

RE:
SQLPLUS way will work - just have to supply connection string in double quotes to stop dos chopping off at the space:

sqlplus "sys/ as sysdba"