Grant privilege in oracle 12c by manual

Question

I use SQL developer on Oracle 12c. I want to create a grant like

 GRANT  SELECT,  INSERT,  UPDATE,  DELETE ON  schema.books TO books_admin;

By manual. I use SQL developer Version 4.1.4.21 . How can I do that?

Answer 1

Using SQL Developer, this can be achieved with below steps ;

1. Right click on Table (to which access needs to be granted) --> Privileges --> Grant [as shown in below diagram].

2. Then assign the user & permissions to be granted [as shown in below diagram].

3. Click Apply.