Re: retroactive GRANT privledges to ROLES

From: DA Morgan <damorgan_at_exxesolutions.com>
Date: Thu, 27 Mar 2003 17:06:47 -0800
Message-ID: <3E83A027.3456C980@exxesolutions.com>

mmeandro wrote:

> My friend says the following, IN CHRONOLOGICAL ORDER:
> 1. Make user SCOTT a ROLE of STUDENT
> 2. GRANT New privledges to the ROLE STUDENT.
> 3. User SCOTT doesnot automatically get the new privledges of STUDENT
> you must REMOVE user SCOTT and then make him ROLE of STUDENT again to
> pick up the new privledges.
>
> Is this true?
> Is there some "flag" my friend forgot to set when setting up the
> database so that ROLE changes are retroactive to the individual users.
> This seems strange but according to him he has learned the "hardway"
> this is true.

No. Your friend knows little about Oracle. Do not take advice from this person. They may or may not be a friend but they are not a source of knowledge about Oracle.

As soon as you grant the role to the schema owner the privileges immediately take effect. Dropping a user drops all tables, etc.

Daniel Morgan Received on Thu Mar 27 2003 - 19:06:47 CST