本文演示了如何使用Oracle SQL创建用户pdm，并为其分配默认表空间ts_pdm，同时授予创建序列、会话、表和视图等权限的过程。通过实际操作命令展示完整的配置步骤。
[size=large]SQL> create user pdm identified by pdm;
SQL> create tablespace ts_pdm datafile 'D:\oracle-datafile\pdm\pdm-data.dbf' size 100m;
SQL> alter user pdm default tablespace ts_pdm;
SQL> grant create sequence,create session,create table,create view,unlimited tablespace to pdm;
SQL> conn pdm/pdm;
SQL> @D:\pdm.sql;[/size]
SQL> create tablespace ts_pdm datafile 'D:\oracle-datafile\pdm\pdm-data.dbf' size 100m;
SQL> alter user pdm default tablespace ts_pdm;
SQL> grant create sequence,create session,create table,create view,unlimited tablespace to pdm;
SQL> conn pdm/pdm;
SQL> @D:\pdm.sql;[/size]
扫一扫
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
