Hi all,
11.2.0.1
What specific privilege can I grant truncate table to a user?
I am confused:
Connect as SYS:
SQL> grant all on HR.EMP to SCOTT;
Grant succeeded.
Connect as SCOTT:
SQL> truncate table HR.EMP;
Table truncated.
Connect as SYS:
SQL> revoke all on HR.EMP from SCOTT;
Revoke succeeded.
Connect as SCOTT:
SQL> truncate table HR.EMP;
Table truncated.
Why can SCOTT still truncate the table?
Thanks,