HOW TO GRANT A ROLE WITH DEFAULT=NO
superdbaAug 27 2009 — edited Aug 27 2009hi,
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