Revoke privileges from SECADM

Mohamed Esmael

Revoke privileges from SECADM

Hello ALL

 Can i revoke creation of column mask and creation of row permission from secadm authority 

Peter Vanroose

Re: Revoke privileges from SECADM
(in response to Mohamed Esmael)

Yes, you can:

            REVOKE CREATE_SECURE_OBJECT FROM <user_id> BY <original_grantor>

Of course, you must be SECADM in order to perform this REVOKE ;-)

In Reply to Mohamed Zaki:

 Can i revoke creation of column mask and creation of row permission from secadm authority

P.S. Haven't tried this out for myself; I might be overlooking some details...

--      Peter Vanroose
        ABIS Training & Consulting,
        Leuven, Belgium.
        http://www.abis.be/