| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: Protecting Passwords In SQL Scripts
Paul Taylor wrote:
>
> Is it possible to connect to a database through the use of an
> encrypted password ?
> I'd like to be able to run a script as a non DBA user, allowing the
> script to connect as a special user without disclosing the password.
>
That sounds hard to do. If you can implement your script as a stored procedure, then the 'special user' can own this procecure, and grant execute access to the non DBA users as needed. You also have complete control over what the non DBA user is allowed to do.
 |
 |