Re: a user to use only import

From: tof <tof_at_debian.linux>
Date: Mon, 21 Aug 2006 21:51:36 +0200
Message-Id: <pan.2006.08.21.19.51.36.485619@debian.linux>

Le Mon, 21 Aug 2006 21:30:15 +0200, Frank van Bortel a écrit :

> 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>
thanks for your help.

I try it. But with no create session privilege, it don't run.

See for example

SQL> create user batch identified by batch;

Utilisateur créé.

SQL> grant exp_full_database to batch;

Autorisation de privilèges (GRANT) acceptée.

SQL> oracle_at_debian:~$ exp batch/batch full=y file=test.dump

Export: Release 10.2.0.1.0 - Production on Lun. Août 21 21:51:11 2006

EXP-00056: Erreur ORACLE 1045 rencontrée ORA-01045: user BATCH lacks CREATE SESSION privilege; logon denied Nom utilisateur :

christophe Received on Mon Aug 21 2006 - 14:51:36 CDT