***Security via enabling roles?***

From: Michael Shapiro <MiShapiro_at_pop200.gsfc.nasa.gov>
Date: 1997/08/01
Message-ID: <5rstsg$cj3@post.gsfc.nasa.gov>#1/1

Hello World!

I have 5 groups of users and I've assigned a role for each group. I have granted corresponding privelages to each role on the Server 7.3.2.

My application on the client machine uses store procedures along with the embeded SQL.

I'd like to set the role when my application starts so that the privelages will be avilable via store procedure and embeded SQL on the client and expect it to be disabled automatically when my application terminates.

Is there any way I can do it in ORACLE?

TIA Received on Fri Aug 01 1997 - 00:00:00 CDT