Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> URGENT Pb with Oracle 9i Create User
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
![]() |
![]() |