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

2024-12-02 17:54:46
推荐回答(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;