Re: [Q] recreate role on another database??

From: Frank van Bortel <fvanbortel_at_netscape.net>
Date: Mon, 09 May 2005 22:13:04 +0200
Message-ID: <d5og0i$hc3$2@news3.zwoll1.ov.home.nl>

aaa wrote:
> We have a ORACLE role with 50 different object privileges grant to it. Does
> there has way to generate a script which I can bring this script to another
> database and re-create it?
>
>
> Thanks.
>

There is.
Read the manual about the data dictionary views. Search for anything with ROLE in it for starters.

-- 
Regards,
Frank van Bortel

Received on Mon May 09 2005 - 15:13:04 CDT

This message: [ Message body ]
Next message: xhoster_at_gmail.com: "Re: Checking if more than 0 rows exist."
Previous message: Frank van Bortel: "Re: Is commit necessary"
In reply to: aaa: "[Q] recreate role on another database??"
Next in thread: Mark D Powell: "Re: recreate role on another database??"
Reply: Mark D Powell: "Re: recreate role on another database??"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US