Hi
Do you know of a way to call oracle stored procedure without supplying user name and pwd ?
On the oracle stage there's a check box "use os level authentication" that works
Thank's
Calling oracle stored procedure with os level authentication
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 87
- Joined: Sat Jul 14, 2007 2:24 pm
If you google "sqlplus with no password" you should get some hits on how this might be done. Most likely the quickest is to use a very restricted user and password that can be made public, i.e. User "restricted", password "restricted" that can only do those queries that you specify.
Otherwise you could use scripts available on the internet to grant access without making the password visible.
Otherwise you could use scripts available on the internet to grant access without making the password visible.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Premium Member
- Posts: 87
- Joined: Sat Jul 14, 2007 2:24 pm
I don't have access right now to DataStage to test out what you ask, perhaps someone else might know the answer.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
Re: Calling oracle stored procedure with os level authentica
??asaf_arbely wrote:On the oracle stage there's a check box "use os level authentication" that works
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Premium Member
- Posts: 87
- Joined: Sat Jul 14, 2007 2:24 pm
There's nothing documented except here, I believe. You can put "call sp_name" either before or after sql, typically before if the sproc is a target. Then you'll need something that does 'nothing' in the actual sql tab - delete or modify something you know will never succeed, this as a 'no-op' since the goal is to simply execute the before-sql.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers