Re: Developer 2000: can't change a role

[Quoted] [Quoted] I created the roles and granted them to the user.

dbms_session.set_role (the_role identified by the_password);

works properly from SqlPlus (from anonymous PL/SQL block) for the user but it [Quoted] doesn't work from Forms 5 for the same user! [Quoted] Now, when I have found that the code doesn't work in Forms my form has the only [Quoted] WHEN-NEW-FORM-INSTANCE trigger with the only statement. Nevertheless the [Quoted] [Quoted] ora-00600 (internal error code) is being occurred.

Thank you very much for your help and kind attention.

Neville Sweet wrote:

> We are using Oracle 8.0.5, but were using 7.1.6.2.0 until a year ago. The
> library procedure has been in use for a number of years.
>
> The library procedure reads all roles from dba_role_privs for the current
> user, packs a comma-delimited string of all granted roles, and issues
> dbms_session.set_role (all roles have the same password). We do this because
> for security reasons all update roles are disabled by default, and enabled
> after logon to a form. One of the pre-requisites for dbms_session.set_role
> is that the roles must have already been granted to the user, but since the
> roles are selected from dba_role_privs this condition is obviously met.
> Have you created the roles and granted them to the user?
>
> Hope this helps,
> Neville.
>
> >Your Name wrote in message
> <01bf8dc9$9e0a95e0$6740e783_at_pc95-adpsb.lboro.ac.uk>...
> >Mike,
> >
> >I don't know if you had any success with Neville's suggestion but we are
> still getting Oracle error messages when trying to set role. If >you or
> Neville have a solution could you please give us some further details.
> >
> >Regards
> >Pali Bains

--
Best wishes,
 Mike