0% found this document useful (0 votes)
23 views4 pages

Oracle User Creation SQL Scripts

Uploaded by

spada1975
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as TXT, PDF, TXT or read online on Scribd
0% found this document useful (0 votes)
23 views4 pages

Oracle User Creation SQL Scripts

Uploaded by

spada1975
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as TXT, PDF, TXT or read online on Scribd

@/home/oracle/dbscripts/PCCell1.De1/Oracle/BAW21OH/bawpcpdw/createUser.

sql
Enter value for 1: bawpcpdw
old 1: CREATE USER bawpcpdw IDENTIFIED BY &1
new 1: CREATE USER bawpcpdw IDENTIFIED BY bawpcpdw

User created.

Grant succeeded.

Grant succeeded.

Grant succeeded.

Grant succeeded.

Grant succeeded.

grant select on pending_trans$ to bawpcpdw


*
ERROR at line 1:
ORA-00942: table or view does not exist

Grant succeeded.

Grant succeeded.

Grant succeeded.

@/home/oracle/dbscripts/PCCell1.De1/Oracle/BAW21OH/bawpcicn/[Link]
Enter value for 1: bawpcicn
old 1: CREATE USER bawpcicn IDENTIFIED BY &1
new 1: CREATE USER bawpcicn IDENTIFIED BY bawpcicn

User created.

Grant succeeded.

Grant succeeded.

Grant succeeded.
Grant succeeded.

Grant succeeded.

grant select on pending_trans$ to bawpcicn


*
ERROR at line 1:
ORA-00942: table or view does not exist

Grant succeeded.

Grant succeeded.

Grant succeeded.

@/home/oracle/dbscripts/PCCell1.De1/Oracle/BAW21OH/bawpcps/[Link]
Enter value for 1: bawpcps
old 1: CREATE USER bawpcps IDENTIFIED BY &1
new 1: CREATE USER bawpcps IDENTIFIED BY bawpcps

User created.

Grant succeeded.

Grant succeeded.

Grant succeeded.

Grant succeeded.

Grant succeeded.

grant select on pending_trans$ to bawpcps


*
ERROR at line 1:
ORA-00942: table or view does not exist

Grant succeeded.

Grant succeeded.

Grant succeeded.
@/home/oracle/dbscripts/PCCell1.De1/Oracle/BAW21OH/bawpcdos/createUserTablespace_EC
[Link]

Tablespace created.

Enter value for 1: bawpcdos


old 1: CREATE USER bawpcdos PROFILE DEFAULT IDENTIFIED BY &1 DEFAULT TABLESPACE
DOSSA_DATA_TS TEMPORARY TABLESPACE TEMP ACCOUNT UNLOCK
new 1: CREATE USER bawpcdos PROFILE DEFAULT IDENTIFIED BY bawpcdos DEFAULT
TABLESPACE DOSSA_DATA_TS TEMPORARY TABLESPACE TEMP ACCOUNT UNLOCK

User created.

Grant succeeded.

Grant succeeded.

Grant succeeded.

Grant succeeded.

Grant succeeded.

grant select on pending_trans$ to bawpcdos


*
ERROR at line 1:
ORA-00942: table or view does not exist

Grant succeeded.

Grant succeeded.

Grant succeeded.

@/home/oracle/dbscripts/PCCell1.De1/Oracle/BAW21OH/bawpctos/createUserTablespace_EC
[Link]

Tablespace created.

Enter value for 1: bawpctos


old 1: CREATE USER bawpctos PROFILE DEFAULT IDENTIFIED BY &1 DEFAULT TABLESPACE
TOSSA_DATA_TS TEMPORARY TABLESPACE TEMP ACCOUNT UNLOCK
new 1: CREATE USER bawpctos PROFILE DEFAULT IDENTIFIED BY bawpctos DEFAULT
TABLESPACE TOSSA_DATA_TS TEMPORARY TABLESPACE TEMP ACCOUNT UNLOCK

User created.

Grant succeeded.

Grant succeeded.

Grant succeeded.

Grant succeeded.

Grant succeeded.

grant select on pending_trans$ to bawpctos


*
ERROR at line 1:
ORA-00942: table or view does not exist

Grant succeeded.

Grant succeeded.

Grant succeeded.

You might also like