how to create a user in oracle using shell script
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
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
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
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
New contributor
New contributor
asked 2 mins ago
Raghu
1
1
New contributor
New contributor
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