hi people
what is the thing i am missing here
SQL> connect sys/syscdb5@pdb1 as sysdba
Connected.
SQL> create user dba1 identified by dba1 default tablespace users quota unlimited on users;
User created.
SQL> create user user1 identified by user1 default tablespace users quota 20m on users;
User created.
SQL> grant dba to dba1;
Grant succeeded.
SQL> grant connect , resource to user1;
Grant succeeded.
SQL> connect dba1/dba1@pdb1
Connected.
SQL> purge dba_recyclebin ;
purge dba_recyclebin
*
ERROR at line 1:
ORA-01031: insufficient privileges
SQL> grant purge dba_recyclebin to user1;
Grant succeeded.
regards..