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.
Received on Thu Mar 27 2003 - 16:13:50 CST
