Re: Help moving from Application to Database Security

"Steve S" <stevens_at_coloradocustomware.com> wrote in message news:bafba412.0105301243.7793df99_at_posting.google.com...
> Our commercial application is using the "One Big Application User"
> model.
> We athenticate users using the Microsoft Jet security engine on the
> front end and a single super database user in Oracle.
> I am researching ways to move the whole thing to Oracle security. We
> use a Jet group membership check to turn things on and off in the
> interface. I plan to use roles in the same way we are using groups
> and I need a way to query for what roles the current user has.
> Does anyone know where to query for that info?

The easiest way: connect as the user in sqlplus and issue select * from session_roles

and
select * from session_privs

Somehow, I guess the user has *ALL* privileges

Hth,

Sybrand Bakker, Oracle DBA Received on Wed May 30 2001 - 16:38:11 CDT