script to alter a user with default role
- From: lyallbarbour@xxxxxxxxxxxxxxx
- To: oracle-l@xxxxxxxxxxxxx
- Date: Mon, 29 Mar 2010 16:39:12 -0400
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
Other related posts:
