DBA Hub

📋Steps in this guide1/1

Create user in oracle

SYNTAX :

oracle configurationintermediate
by OracleDba
14 views
1

Create user in oracle

-To create an user, which will prompt for new password upon login:

Code/Command (click line numbers to comment):

1
2
3
4
5
6
7
8
9
10
SYNTAX :
create user identified by default tablespace   temporary tablespace ;
Eg:
create user SCOTT identified by oracle#41234
default tablespace users
temporary tablespace TEMP;
create user SCOTT identified by oracle#41234
default tablespace users
temporary tablespace TEMP
password expire;

Comments (0)

Please to add comments

No comments yet. Be the first to comment!