how to create a user in oracle using shell script

Multi tool use
Clash Royale CLAN TAG#URR8PPP
up vote
0
down vote
favorite
CREATE USER test1
IDENTIFIED BY test123
DEFAULT TABLESPACE USERS
TEMPORARY TABLESPACE TEMP
PROFILE USERS
ACCOUNT UNLOCK;
GRANT CREATE SESSION TO test1;
GRANT CONNECT,RESOURCE TO test1;
GRANT SSE_ROLE TO test1;
shell
New contributor
Raghu is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
add a comment |Â
up vote
0
down vote
favorite
CREATE USER test1
IDENTIFIED BY test123
DEFAULT TABLESPACE USERS
TEMPORARY TABLESPACE TEMP
PROFILE USERS
ACCOUNT UNLOCK;
GRANT CREATE SESSION TO test1;
GRANT CONNECT,RESOURCE TO test1;
GRANT SSE_ROLE TO test1;
shell
New contributor
Raghu is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
add a comment |Â
up vote
0
down vote
favorite
up vote
0
down vote
favorite
CREATE USER test1
IDENTIFIED BY test123
DEFAULT TABLESPACE USERS
TEMPORARY TABLESPACE TEMP
PROFILE USERS
ACCOUNT UNLOCK;
GRANT CREATE SESSION TO test1;
GRANT CONNECT,RESOURCE TO test1;
GRANT SSE_ROLE TO test1;
shell
New contributor
Raghu is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
CREATE USER test1
IDENTIFIED BY test123
DEFAULT TABLESPACE USERS
TEMPORARY TABLESPACE TEMP
PROFILE USERS
ACCOUNT UNLOCK;
GRANT CREATE SESSION TO test1;
GRANT CONNECT,RESOURCE TO test1;
GRANT SSE_ROLE TO test1;
shell
shell
New contributor
Raghu is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
New contributor
Raghu is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
New contributor
Raghu is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
asked 2 mins ago
Raghu
1
1
New contributor
Raghu is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
New contributor
Raghu is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
Raghu is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
add a comment |Â
add a comment |Â
active
oldest
votes
active
oldest
votes
active
oldest
votes
active
oldest
votes
active
oldest
votes
Raghu is a new contributor. Be nice, and check out our Code of Conduct.
Raghu is a new contributor. Be nice, and check out our Code of Conduct.
Raghu is a new contributor. Be nice, and check out our Code of Conduct.
Raghu is a new contributor. Be nice, and check out our Code of Conduct.
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2funix.stackexchange.com%2fquestions%2f478152%2fhow-to-create-a-user-in-oracle-using-shell-script%23new-answer', 'question_page');
);
Post as a guest
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password