Which four options for modification of a role are feasible using Enterprise Manager?

Which four options for modification of a role are feasible using Enterprise Manager? (Choose four.)

Which four options for modification of a role are feasible using Enterprise Manager? (Choose four.)

A.
Grant new roles to the role.

B.
Grant new users to the role.

C.
Grant new privileges to the role.

D.
Revoke existing roles from the role.

E.
Revoke existing users from the role.

F.
Revoke existing privileges from the role.

Explanation:

SQL> create role trial;
Role created.
A : SQL> grant connect to trial;
Grant succeeded.
D : SQL> grant resource to trial;
Grant succeeded.
F: SQL> revoke resource from trial;
Revoke succeeded.
B : SQL> grant praquery to trial;
grant praquery to trial
*
ERROR at line 1:
ORA-01919: role ‘PRAQUERY’ does not exist
here praquery is user



Leave a Reply 0

Your email address will not be published. Required fields are marked *