Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> URGENT Pb with Oracle 9i Create User

URGENT Pb with Oracle 9i Create User

From: Sébastien FOUILLOUX <sfouilloux_at_dotsmartcard.net>
Date: Wed, 12 Jun 2002 15:41:35 +0200
Message-ID: <ae7jrk$u6v$1@norfair.nerim.net>


Re

Here all SQL command that I commit on SQL*PLUS : Did you think that it's right ??

CREATE USER "ADMINISTRATEUR" PROFILE "DEFAULT"     IDENTIFIED BY "AQWZSX" DEFAULT TABLESPACE "SYSTEM"     TEMPORARY TABLESPACE "TEMP"
    ACCOUNT UNLOCK; GRANT UNLIMITED TABLESPACE TO "ADMINISTRATEUR" PROFILE "SCOTT" GRANT ALTER, INDEX, DELETE, REFERENCES, INSERT, SELECT, UPDATE     ON "SCOTT"."CLIENT" TO "ADMINISTRATEUR" GRANT ALTER, DELETE, INDEX, INSERT, REFERENCES, SELECT, UPDATE     ON "SCOTT"."PLACE_DISPO" TO "ADMINISTRATEUR" GRANT ALTER, DELETE, INDEX, INSERT, REFERENCES, SELECT, UPDATE     ON "SCOTT"."RESA" TO "ADMINISTRATEUR" GRANT ALTER, DELETE, INDEX, INSERT, REFERENCES, SELECT, UPDATE     ON "SCOTT"."VOL" TO "ADMINISTRATEUR" GRANT "CONNECT" TO "ADMINISTRATEUR";
GRANT "RESOURCE" TO "ADMINISTRATEUR"; Thank's Received on Wed Jun 12 2002 - 08:41:35 CDT

Original text of this message

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