Re: GRANT question

Yeah, I know of a simple solution to that problem. It is kinda like the "Rambo" way of doing it though. If you knock off the instance you will force the user to log back on. But actually, I am not sure why you aren't seeing the changes made in realtime, regardless of whether they are logged in or not. If I have a user logged into SQL*PLUS, me as the DBA can grant and revoke roles and the user will see those changes made immediately. For example if I revoke DBA from the user:

    REVOKE "DBA" FROM "MARKETING";
    REVOKE UNLIMITED TABLESPACE FROM "MARKETING";     ALTER USER "MARKETING" DEFAULT ROLE ALL; and the user types the following:

    select * from USER_ROLE_PRIVS;

The user will see:

USERNAME                       GRANTED_ROLE                   ADM DEF OS_
------------------------------ ------------------------------ --- --- ---
MARKETING                         RESOURCE                       NO  YES NO

When the user originally had DBA priviledges. Is this similar to what you are trying to do?

Good Luck,
Kevin

meyer_b_at_rocketmail.com wrote:

> Ordinarily, if I change the grants I've given someone, that change won't take
> effect until the next time they log on. Is it possible to force the change to
> take effect immediately, even if the user is currently logged on?
>
> Thanks much,
>
> Bob Meyer
>
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Received on Thu Oct 29 1998 - 08:05:29 CST