>
> Please let me know if I am missing something here.
>
> Thanks
> Shaleen
>
> - Original Message -
> From: "Jared Still" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>; "Shaleen" <[EMAIL PROTECTED]>
> Sent: Wednesd
ot; <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>; "Shaleen" <[EMAIL PROTECTED]>
> Sent: Wednesday, December 25, 2002 11:09 PM
> Subject: Re: unable to create stored outline for sql inside a
> procedure --Resolved
>
> > Shaleen,
> >
> > This i
jared,
Thanks for explanation. Still not convinced because of following two reasons
1) Same scenario can happen with explicit privileges as well. User A grants
ALL privileges on MY_TABLE to B without GRANT OPTION. Now B can create a
stored procedure to do DML on MY_TABLE and grant execute permiss
Shaleen,
This is done to preserve security.
User A owns a table MY_TABLE.
Role A_STUFF allows insert, select, update, delete on A.MY_TABLE.
grant insert,select,update,delete on MY_TABLE to A_STUFF;
( note that the role was not granted admin privs on the table )
User B is granted role A_STUF
All,
Oracle support was able to resolve this issue for
me and I would like to share the learning. The problem was that I was unable to
create stored outline for sql executing within a stored procedure after turning
create_stored_outlines=true. Create outlines for sql satetements executing f