Re: t have two problemms about oracle authentication,can you help me?

ldd600_at_163.com schreef:

> SQL> select * from session_roles;
>
> ROLE
> ------------------------------
> CONNECT
> RESOURCE
> B
> A
>
>
> SQL> set role a;
>
> Role set
>
> SQL> select * from session_roles;
>
> ROLE
> ------------------------------
> A
>
> -----------------------------------------------------------------------------------------------------------------

Then why don't you use the above set role statement? Another option would be not to enable the role, and have the application issue the set role statement(s).

Not sure I understand your problem, so if this makes no sense at all, sorry.

-- 
Regards,
Frank van Bortel

Top-posting is one way to shut me up...