Can a user be given two roles...? If so, one role will have execute privileges and the other role will have DBA privileges. Can a user be able to connect to any one of the roles...? like connect system as sysdba...?

This is quite urgent...

regards,
Srikanth