role!!

[launchpad]

Hi all , if by mistake i creaete a role with name ALL .. and grant it to a user saying ALTER USER X1 DEFAULT ROLE ALL ; what will happen ? another small query rgd pctfree and pctused . if i change the param. when they wil come into the effect ? needa i bounce the instance ?
thanx in advance ..

[jmodic]

[QUOTE][i]Originally posted by launchpad [/i]
[B]Hi all , if by mistake i creaete a role with name ALL .. and grant it to a user saying ALTER USER X1 DEFAULT ROLE ALL ; what will happen ?[/B][/QUOTE]

When you try to creat a role with the name ALL you'll get "ORA-01937: missing or invalid role name"

[QUOTE][B]...another small query rgd pctfree and pctused . if i change the param. when they wil come into the effect ? needa i bounce the instance ?
thanx in advance .. [/B][/QUOTE]

No you don't need to bounce your db, those parameters are effective immediatelly.

HTH,