Have a question as follows:
sqlplus login as user A, want to grant another user B's sequence to a role, that is,
grant select on b.sequence1 to r1;
Got the error:
ERROR at line 1:
ORA-01031: insufficient privileges
What kind of privilege does user A need to grant another user's sequence to a role?
Please, can any guru shed some light on this?