Re: a user to use only import

From: Frank van Bortel <frank.van.bortel_at_gmail.com>
Date: Mon, 21 Aug 2006 21:30:15 +0200
Message-ID: <ecd1ba$s3j$1@news1.zwoll1.ov.home.nl>

tof schreef:
> Hi,
>
> i create a user for use only for import and for export.
> batch_export with exp_full_database role <- It run
> batch_import with imp_full_database role <- don't run
>
> P:\>sqlplus batch_export/batch
>
> SQL*Plus: Release 10.1.0.2.0 - Production on Lun. Ao¹t 21 17:21:58 2006
>
> Copyright (c) 1982, 2004, Oracle. All rights reserved.
>
> ERROR:
> ORA-00604: une erreur s'est produite au niveau SQL rÚcursif 1
> ORA-20000: Connexion refusee
> ORA-06512: Ó ligne 41
>
>

Time to patch, I'd say:

[oracle10_at_csdb01 oracle10]$ sqlplus '/as sysdba'

SQL*Plus: Release 10.1.0.4.0 - Production on Mon Aug 21 21:22:34 2006

Copyright (c) 1982, 2005, Oracle. All rights reserved.

Connected to an idle instance.

SQL> startup
ORACLE instance started.

Total System Global Area 285212672 bytes

Fixed Size                   778856 bytes
Variable Size             133176728 bytes
Database Buffers          150994944 bytes
Redo Buffers                 262144 bytes

Database mounted.
Database opened.

SQL> create user test identified by test; User created.

SQL> grant imp_full_database to test;
Grant succeeded.

SQL> connect test/test
ERROR:
ORA-01045: user TEST lacks CREATE SESSION privilege; logon denied

Warning: You are no longer connected to ORACLE. SQL>

-- 
Regards,
Frank van Bortel

Top-posting is one way to shut me up...

Received on Mon Aug 21 2006 - 14:30:15 CDT