What is wrong with: select "alter user " || username || " default role all;" from all_users; Adar Yechiel Rechovot, Israel lyallbarbour@xxxxxxxxxxxxxxx wrote:
Has someone done this before? it's hurting my brain.i want to grab all the roles that are granted to a user and add it to an alter statement on the fly. alter user foo default role "granted_role", "granted_role", append, append, append as needed depending on how many roles a user has. I was hoping to make a select 'alter user... ' type of thing. Lyall