跳至主要內容

创建用户语句

三思原创大约 1 分钟oracle用户语句创建用户oracle

这篇文章介绍了一幅美丽的插画作品,展示了一个穿着和服的女孩,背景是樱花盛开的场景。插画充满了浪漫和优雅的氛围,给人一种清新动人的感觉。

image
image

创建用户语句

-- Create the user 
drop user ehrss_accept cascade;
create user ehrss_accept
  default tablespace USERS
  temporary tablespace TEMP
  identified by ehrss_accept
  profile DEFAULT;
-- Grant/Revoke role privileges
grant connect to ehrss_accept;
--grant dba to ehrss_accept;
grant resource to ehrss_accept with admin option;
-- Grant/Revoke system privileges
grant alter any table to ehrss_accept;
grant alter tablespace to ehrss_accept;
grant create any job to ehrss_accept;
grant create any procedure to ehrss_accept;
grant create any sequence to ehrss_accept;
grant create any synonym to ehrss_accept;
grant create any table to ehrss_accept;
grant create any trigger to ehrss_accept;
grant create any view to ehrss_accept;
grant create database link to ehrss_accept;
grant create public synonym to ehrss_accept;
grant create sequence to ehrss_accept;
grant create session to ehrss_accept;
grant create synonym to ehrss_accept;
grant create table to ehrss_accept;
grant create view to ehrss_accept;
grant debug any procedure to ehrss_accept;
grant debug connect session to ehrss_accept with admin option;
grant drop any sequence to ehrss_accept;
grant execute any procedure to ehrss_accept;
grant insert any table to ehrss_accept;
grant select any dictionary to ehrss_accept with admin option;
grant select any sequence to ehrss_accept;
grant select any table to ehrss_accept;
grant unlimited tablespace to ehrss_accept with admin option;
grant update any table to ehrss_accept;