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...?
a user can definitely have more than one role at any time but do remember that the user will have only one default role aslo the other roles can be enabled or disabled with the set role command, one thing to remember here is that the sysdba privilege is a very special privelege which is similar to the user internal, which again is none other then sys connecting as sysdba, this role and sysoper has to be set in a special way, pls. go thro. oracle documentation for doing this and also be aware that there are some roles that cannot be granted via another role, i.e., they have to be explicitly assigned to the user.,the oracle documentation will give u all this info. is this ok or any more clarifications, do write
The scenario is, I have two roles one role will be a DBA role who can do anything and the other is a developer role who will not have any create privilege. How can we shuffle around these two roles by a single user....?