Re: script to alter a user with default role
- From: Yechiel Adar <adar666@xxxxxxxxxxxx>
- Date: Thu, 08 Apr 2010 19:50:28 +0300
You are correct in principal, but he said he wanted to create:
alter user default role (all the roles assign to the user).
In this case default role all does the work.
Adar Yechiel
Rechovot, Israel
David Fitzjarrell wrote:
Syntactically it's the double quotes; strings are enclosed in single
quotes. As to setting 'default role all' that really depends upon
which roles these users are granted and whether or not those roles
SHOULD be set as default. Administrative roles granted to essentially
non-administrative users should not be default (in my opinion) as they
are (or should be) granted for emergency use (the department manager
is off in Aruba and the only DBA was hit by a bus on her way back to
the office from lunch and is now in the emergency room).
David Fitzjarrell
Other related posts:
