Re: Default Roles And A Caution in oracle docs

If you create all the rows under your DBA id you can prevent exceeding the assinged limit for active roles by revoking the role from yourself.

UT1 > create role demo1;

Role created.

UT1 > revoke demo1 from mpowel01;

Revoke succeeded.

UT1 > grant select on jit.item_master to demo1;

Grant succeeded.

The role is fine and can be granted privileges and granted to users as normal. It just is no longer a default role for the creating id.

HTH -- Mark D Powell -- Received on Tue Aug 09 2005 - 08:30:40 CDT