Re: a user to use only import


"delcenserie christophe" <tof@xxxxxxxxxxxx> wrote in message
news:pan.2006.08.22.04.56.39.425199@xxxxxxxxxxxxxxx
thanks for your help.

I have the solution. (from the forum oracle.com)

http://download-uk.oracle.com/docs/cd/B10501_01/server.920/a90842/ch10.htm#1005767

for example :

At system user

SQL> INSERT INTO PRODUCT_USER_PROFILE values ('SQL*Plus', 'BATCH',
'CONNECT',null,null, 'DISABLED', NULL, NULL);

1 ligne créée.

SQL> grant create session to batch;

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

SQL> INSERT INTO PRODUCT_USER_PROFILE values ('SQL*Plus', 'BATCH',
'SELECT',null,null, 'DISABLED', NULL, NULL);

1 ligne créée.

the result

oracle@debian:~$ sqlplus batch/batch;

SQL*Plus: Release 10.2.0.1.0 - Production on Mar. Août 22 06:53:00 2006

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


Connecté à :
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options

SQL> select user from dual;
SP2-0544: Commande "select" désactivée dans le profil utilisateur du
produit
SQL>

oracle@debian:~$ exp batch/batch owner=batch file=test.dump

Export: Release 10.2.0.1.0 - Production on Mar. Août 22 06:54:32 2006

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


Connecté à : Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 -
Production
With the Partitioning, OLAP and Data Mining options
Export fait dans le jeu de car WE8DEC et jeu de car NCHAR AL16UTF16
le serveur utilise le jeu de caractères WE8ISO8859P1 (conversion possible)

Prêt à exporter les utilisateurs spécifiés ...
. export des actions et objets procéduraux de pré-schéma
. export des noms de bibliothèque de fonctions étrangères pour
l'utilisateur BATCH
. export des synonymes de type PUBLIC
. export des synonymes de type PRIVATE
...



Thanks for all

Nice, I even didn't know (or remember :-)) that this existed. I learned
something new today :-)


Matthias


.

Relevant Pages

  • Re: PRIVILEGE PROBLEMS USING EXECUTE IMMEDIATE!
    ... >>> Michel Cadot ... > The permissions are a direct grant to the SCHEMA2 user. ... > SQL> grant alter,insert, update, delete, select ON TESTTAB to scott2; ... > PL/SQL procedure successfully completed. ...
    (comp.databases.oracle.server)
  • Re: all operation not work (insert delete update) / maybepermissionproblem
    ... The database server cannot find a table or view specified in the statement. ... trying to grant USAGE privileges on a user-defined type. ... Betreff: Re: all operation not work / maybe permissionproblem ... I called this command just you are told me: onstat -g sql and I got the following: ...
    (comp.databases.informix)
  • Re: SQL connection
    ... >>> I need to use user authentication, ... Maybe set in SQL ... >> privileges both on the instance (grant login) and on the db and relative ...
    (microsoft.public.vb.database)
  • Re: PRIVILEGE PROBLEMS USING EXECUTE IMMEDIATE!
    ... >> Michel Cadot ... The permissions are a direct grant to the SCHEMA2 user. ... SQL> grant alter,insert, update, delete, select ON TESTTAB to scott2; ... SQL> create or replace procedure DoIt IS ...
    (comp.databases.oracle.server)
  • Re: SQL 6.5 sa Password, how to change?
    ... After changing it I can no longer connect to SQL ... > combination of letters, numbers, and symbol characters within the ... > and is not a dictionary word, command name, person's name, or system user ...
    (microsoft.public.sqlserver.security)