[Q] recreate role on another database??
01/01/2018 11:47
We have a ORACLE role with 50 different object privileges grant to it. Doesthere has way to generate a script which I can bring this script to anotherdatabase and re-create it? Thanks.Source is Usenet: comp.databases.oracle.server
Sign in to add a comment
Answer score: 5
01/01/2018 11:47 - There is.Read the manual about the data dictionary views.
Search for anything with ROLE in it for starters.
Source is Usenet: comp.databases.oracle.server
Sign in to add a comment
Answer score: 5
01/01/2018 11:47 - Sample code to do something similar can be found in How do I find out which users have the rights, or privileges, to accessa given object ? http://www.jlcomp.demon.co.uk/faq/privileges.html HTH -- Mark D Powell ---
Source is Usenet: comp.databases.oracle.server
Sign in to add a comment
eDiscover
Search eDiscover
Categories
