Database Administration (MOSC)

MOSC Banner

Grant all privileges (procedures, packages, Functions..) from User-1 to User2

edited May 13, 2014 12:23PM in Database Administration (MOSC) 6 commentsAnswered ✓

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center