Shaleen
Def.Rights:
Roles can be enabled or disabled -- an unit must not be dependent
on the enabled/disabled roles. There is nothing bad to have such
design. This design is well thought, IMHO. At least at it's [was]
consistent [on the moment of its invention].
Inv.right
Due to the context switch
That would be Mary-Ann Davidson. I'll ask her.
Mogens
Jared Still wrote:
This is in conflict with what a few Oracle folks have said.
Interesting. I guess you'd have to ask the oracle security architect
to get the full story.
Jared
On Thursday 26 December 2002 12:39, Khedr, Waleed wrote:
This is in conflict with what a few Oracle folks have said.
Interesting. I guess you'd have to ask the oracle security architect
to get the full story.
Jared
On Thursday 26 December 2002 12:39, Khedr, Waleed wrote:
> This may be more convincing:
>
> http://metalink.oracle.com/metalink/plsql/ml
>
> 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
Hmm. Makes sense. Thanks Tim.
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Thursday, December 26, 2002 2:34 PM
> I don't agree that anyone "shirked". Roles are, by design, changeable
> within a session. The SET ROLE command is not DDL, alteri
I don't agree that anyone "shirked". Roles are, by design, changeable
within a session. The SET ROLE command is not DDL, altering the metadata of
the database. Instead, it is only altering already-granted permissions to
used subsequently by the session. So, why should "permanent" objects (such
Thanks Waleed. For the first time I have understood the reason behind this.
Which is, "Larry shirked"!!
"The reason why roles are disabled in stored procedures is not due to the
roles themselves, but has to do with the dependency model. If roles were
enabled in stored procedures, Oracle would n
This may be more convincing:
http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_datab
ase_id=NOT&p_id=1031418.6
regards,
Waleed
-Original Message-
Sent: Thursday, December 26, 2002 2:19 PM
To: Multiple recipients of list ORACLE-L
--Resolved
jared,
Thanks for expla
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
still dont agree with this concept.
my 02 cents
-Shaleen
- Original Message -
From:
Jamadagni, Rajendra
To: Multiple recipients of list ORACLE-L
Sent: Wednesday, December 25, 2002 9:28
AM
Subject: RE: unable to create stored
outline for sql inside a procedure
-From: Shaleen
[mailto:[EMAIL PROTECTED]]Sent: Tuesday, December 24, 2002
2:14 PMTo: Multiple recipients of list ORACLE-LSubject:
unable to create stored outline for sql inside a procedure
--Resolved
All,
Oracle support was able to resolve this issue for
me and I would like to shar
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
14 matches
Mail list logo
