Grant all privileges (procedures, packages, Functions..) from User-1 to User2
Greetings -
I wanted to create a dynamic script to grab all privileges on [ Procs, Packages, Triggers & Functions ] that are assigned to User1 and assign them to User-2.
Please note, I don't want to run a script that does this on the fly, I'd like to be able to see the output file which I can turn it to a script such as: [ privs_objects.sql ] then run it.
A dynamic script would be ideal, which will give me the option to see what the script will do before I run it.
Thank you.
-AJ