Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

HOW TO GRANT A ROLE WITH DEFAULT=NO

superdbaAug 27 2009 — edited Aug 27 2009
hi,
i m trying to give a role to my user but this role is default=yes in USER_ROLE_PRIVS view.

i want this role to show default=no
if i use
alter user SPC default role none the it converts all role to NO
so how to grant a role that shows default=no

thanxs
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 24 2009
Added on Aug 27 2009
3 comments
12,180 views