Re: Adding some random characters to Oracle password

From: Jeff <jeff_at_work.com>
Date: Tue, 02 Nov 2004 13:51:14 GMT
Message-ID: <cm83ci$qhr$1@cronkite.cc.uga.edu>

In article <4186cf46$0$24988$afc38c87_at_news.optusnet.com.au>, "Howard J. Rogers" <hjr_at_dizwell.com> wrote:

>I'm not sure what role you're talking about. The procedure that actually
>issues the 'set role' command is certinaly not intended to be executed
>manually. It's supposed to be embedded in the application. I mention this
>right at the end of the paper I mentioned.

When I say "manually," I'm talking about having to explicitly execute the procedure from the application... not the user doing it.

>> It would've been cool if the role could be set (or not) in a logon
>> trigger,
>> but of course it can't.
>
>Why not?

Because you cannot set a role in a trigger (even if it's in a SP called by a trigger). At least that's the error message I got when I tried it. Received on Tue Nov 02 2004 - 07:51:14 CST