在oracle中,使用语句创建用户ptms⼀ptmstest,其默认表空间为users

2024年12月02日 17:54
有1个网友回答
网友(1):

create user ptms identified by ptmstest default tablespace users tempprary tablespace temp profiles profile2;
grant create table,create session,create view to ptms;
grant select on scott.emp to ptms with grant option;
grant insert on scott.emp to ptms;