up vote 2 down vote favorite
share [g+] share [fb]

I want to login to a database by running an SQL file from a unix script without supplying username and password (as root)....is this possible?

Database is oracle

link|improve this question
You might want to mention the database, what are the database accounts and permissions, etc. – Keith Mar 1 '11 at 6:03
database is oracle – sam Mar 1 '11 at 6:15
feedback

3 Answers

up vote 1 down vote

You can define your database users as being OS Authenticated. Tim Hall's Oracle_Base site has a good primer on how to do this. You don't need to allow folks to log in with SYSDBA privileges, a recipe for disaster.

link|improve this answer
+1 thx for introducing "OS Authentication". Did not know about it. Will have plenty of opportunity to use it. – Alain Pannetier Mar 1 '11 at 18:28
Oracle also has the ability to authenticate to LDAP servers, e.g., Active Directory for domain authentication. You need a separate piece for that feature - added cost option :-/ – DCookie Mar 1 '11 at 18:35
Indeed I've implemented OID in the past. Just forgot about it... :-( I'll dust off this domain tomorrow. – Alain Pannetier Mar 1 '11 at 21:16
feedback
up vote 1 down vote

If your user is in the oracle group, he can connect as SYSDBA.

Example on a Unix env:

$ export ORACLE_SID=MYDB
$ sqlplus /nolog

SQL*Plus: Release...

SP2-0640: Not connected
sql> connect / as sysdba
Connected

SQL> select * from scott.employees ;

That might be something of an overkill for a batch (besides the fact that you have all privileges to screw up your db).

However AFAIK, that's the only option.

UPDATE Given DCookie's answer, this is not the only way. And as I already mentioned and underlined by DCookie this is a very risky path.

link|improve this answer
It's not the only option, and it's a pretty dangerous one as well. A SYSDBA user can do ANYTHING to the database. Plus, you need to set up the logged in user to be able to log in with these privileges anyway. – DCookie Mar 1 '11 at 17:00
feedback
up vote 0 down vote

If using PostgreSQL then you can specify the "trust" method for your localhost network in the "pg_hba.conf" file. For MySQL there may be something similar, I'm not sure (hopefully someone here who's familiar with whatever database you're using can help with this if it's not PostgreSQL).

link|improve this answer
database is oracle – sam Mar 1 '11 at 6:13
feedback

Your Answer

 
or
required, but never shown
discard

Not the answer you're looking for? Browse other questions tagged or ask your own question.