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

创建用户语句
-- 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;