On 07/12/2012 07:03 pm, Doug Chamberlin wrote:

> On 12/7/12 2:36 AM, Venus Software Operations wrote:
>> What does the default blank role for sysdba mean?
>> That if the data-entry user if they login without a role will have the
>> same powers as sysdba?
> No. Roles attach additional privileges to the user's account. With no
> role specified the user is left with the privileges granted to their
> user account only.
>
> Roles provide a pretty good system. I wish multiple roles could be
> employed at the same time over the same connection but that's about the
> only improvement I would like to see.

Thanks for the explanation Doug. Thinking out loud...

Does this mean if a user themself are grants few rights (RightsA) only
and I login via this user but no role that is all they can do.

Now I grant a role to a user but the rights (RightsB) via this role is
very different from the default rights the user has, does it mean when
the user+role is used to login he gets RightsA+RightsB or just RightsB
because of the role?

Kind regards
Bhavbhuti