Re: EXP: is this expected behaviour?

On Thu, 18 Jul 2002 13:12:46 -0400, "Chuck" <chuckh_at_softhome.net> wrote:

>Oracle 8.1.7.2
>
>I just noticed that a full export of a database does not contain any grants
>on SYS's objects. Is this expected/documented behavior (I haven't found it
>documented in any manual)? I know that a full export/import does not import
>SYS objects but is it supposed to ignore the grants on those objects too? I
>have numerous databases where users need EXECUTE and SELECT privileges on
>some of SYS's objects. If I were to restore those databases from a full
>export they would be screwed up. Is there an option to force the grants to
>be exported, or some other workaround apart from having to export them
>manually?
>

On 8i you can avoid direct grants from SYS by creating the appropiate procedures with authid invoker

Hth

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Thu Jul 18 2002 - 12:53:25 CDT