Below is the syntax, which can used to Huge number of Users in one GO !!------------------------------------------------------------------------ declare cursor cur1 isselect user_name from apps.fnd_user where LOWER(user_name) Not IN ('username','username', .......);beginfor all_user in cur1 loopapps.fnd_user_pkg.EnableUser(all_user.user_name);commit;end loop;End
No comments:
Post a Comment