Oracle users, oracle users

Oracle users, oracle users

Create user ng_zj identified by ng_zj
Default tablespace tbs_test
Temporary tablespace tbs_test_tmp;

Grant connect to ng_zj;
Grant resource to ng_zj;
Grant create table to ng_zj;
Grant create sequence to ng_zj;
Grant create session to ng_zj;
Grant create synonym to ng_zj;
Grant create view to ng_zj;
Grant select any table to ng_zj;
Grant create procedure to ng_zj;
Grant debug connect session to ng_zj;

ORACLE user Creation

The spelling of INDENTIFIED is incorrect. It should be: IDENTIFIED

By the way, when creating a user, you should define its tablespace (default tablespace ). Otherwise, it uses system tablespace ). This should be avoided.

This is an example of common user creation:

Create user xxxxx identified by xxxxx
PROFILE DEFAULT
DEFAULT TABLESPACE USERS
Temporary tablespace TEMPTS01
Account unlock;

Note that you must first check whether there are two tablespaces in your database: USERS and TEMPTS01. If no, create the tablespace USERS and TEMPTS01 before creating the user.

How to create a new user in oracle Database?

Go to oracle in CRT -- connect to sqlplus
Follow the code below to copy it and press Enter.
--- Create user code: create user "username word" PROFILE "DEFAULT" identified by "password" default tablespace "specified TABLESPACE name" temporary tablespace "temporary tablespace" account unlock;
--- Authorization

Begin
Execute immediate 'Grant select any dictionary to username ';
Execute immediate 'Grant alter any table to username ';
Execute immediate 'Grant alter system to username ';
Execute immediate 'Grant alter any procedure to username ';
Execute immediate 'Grant connect to username ';
Execute immediate 'Grant create any procedure to username ';
Execute immediate 'Grant create any table to username ';
Execute immediate 'Grant create any index to username ';
Execute immediate 'Grant create database link to username ';
Execute immediate 'Grant create public database link to username ';
Execute immediate 'Grant create any view to username ';
Execute immediate 'Grant create public synonym to username ';
Execute immediate 'Grant create table to username ';
Execute immediate 'Grant delete any table to username ';
Execute immediate 'Grant drop public database link to username ';
Execute immediate 'Grant drop any trigger to username ';
Execute immediate 'Grant drop any index to username ';
Execute immediate 'Grant drop any procedure to username ';
Execute immediate 'Grant drop any table to username ';
Execute immediate 'Grant drop any view to username ';
Execute im... the remaining full text>