Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

SQR and Passwords

Status
Not open for further replies.
jodi7

jodi7

Technical User
Jan 7, 2003
2
US
How can you pass a password to run SQRs at the UNIX prompt? Can the password be encryted or stored in an Oracle database?
 
Sort by date Sort by votes
Try this on the unix prompt :

sqr sqrprogramname.sqr user/password -Vsqlservername -DBdbname

Notice the "/" character between user and password values

Regards.
Abdaler
 
Upvote 0 Downvote
I guess I was not clear in my question. I need to pull the password from an Oracle table or another file so the developers can run their sqr's without knowing the password.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Ktonthat
  • Locked
  • Question
Where do we update the SQR process email address list
Replies
0
Views
125
Ktonthat
Ktonthat
Ktonthat
  • Locked
  • Question
Tax Class and Earning code
Replies
0
Views
290
Ktonthat
Ktonthat
awood69
  • Locked
  • Question
SQR to XLS Column Number
Replies
0
Views
123
awood69
awood69
merlizbet
  • Locked
  • Question
PeopleSoft Equation Engine (stem variables and Exists questions)
Replies
0
Views
137
merlizbet
merlizbet
jcw12000
  • Locked
  • Question
ERD or List of all tables and table descriptions for Account Payable module NEED UGENT
Replies
0
Views
114
jcw12000
jcw12000

Part and Inventory Search

Sponsor

Back
Top