if you have sysdate inside trigger, security will be encrypted. I know for the regular objects, you have to grnt the objects directly to the user not the role, how do we handle things like SYSDATE, SYSEVENT????
Printable View
if you have sysdate inside trigger, security will be encrypted. I know for the regular objects, you have to grnt the objects directly to the user not the role, how do we handle things like SYSDATE, SYSEVENT????
getting a bit tired of your questions, typical of RTFM
is sysdate a privilege? can you grant sysdate to a user? have you tested this before asking? it´s a very simple test