Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Grant system privilege that i can't use ?(purge dba_recyclebin )example

under_sunJan 6 2018 — edited Jan 13 2018

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..

This post has been answered by JohnWatson2 on Jan 12 2018
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 10 2018
Added on Jan 6 2018
10 comments
2,485 views