Breaking News: Grepper is joining You.com. Read the official announcement!

oracle sql create user

VasteMonde answered on January 20, 2021 Popularity 10/10 Helpfulness 9/10

answer oracle sql create user

related Creating a User in Oracle

oracle sql create user

Comment

-- Oracle - User / schema creation
CREATE USER MY_USER IDENTIFIED BY "MyPassword"
DEFAULT TABLESPACE USERS
TEMPORARY TABLESPACE TEMP PROFILE DEFAULT ACCOUNT UNLOCK;
GRANT CONNECT TO MY_USER;           -- To connect to DB
GRANT RESOURCE TO MY_USER;          -- Access / modify
GRANT MY_ROLE TO MY_USER;           -- Grants a role (to be defined)
ALTER USER MY_USER DEFAULT ROLE "RESOURCE","CONNECT","MY_ROLE";
-- Proxy access
ALTER USER MY_USER GRANT CONNECT THROUGH MY_OTHER_USER;
-- Checks privileges:
SELECT PRIVILEGE FROM DBA_SYS_PRIVS WHERE GRANTEE = MY_USER;

Popularity 10/10 Helpfulness 9/10 Language sql

Source: Grepper

Tags: oracle schema sql

Link to this answer
Share Copy Link

Contributed on Jan 20 2021

VasteMonde

0 Answers Avg Quality 2/10

Closely Related Answers

Creating a User in Oracle

Comment

Once connected as SYSTEM, simply issue the CREATE USER command to generate a new account.

CREATE USER Mahesh IDENTIFIED BY Pass@word1;
Here we’re simply creating a Mahesh account that is IDENTIFIED or authenticated by the specified password.

Popularity 9/10 Helpfulness 4/10 Language sql

Source: Grepper

Tags: oracle or

Link to this answer
Share Copy Link

Contributed on Jan 24 2023

Mahesh Kumar Yadav

0 Answers Avg Quality 2/10

oracle sql create user

Contents

More Related Answers

oracle sql create user

Closely Related Answers

Creating a User in Oracle

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.