Re: Two simple questions.

Gama Franco wrote:

> Hello,
>
> 1 - Is it possible to run a stored procedure using the privileges
> granted to a user through a role? I mean, is there any way to do it?

No.

>
> 2 - How do I inspect the roles of a user using SQL PLUS?
>
> Best regards,
> Gama Franco

SELECT * FROM user_role_privs;

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)