1.创建用户,并分配权限
-- 数据目录根据实际环境替换 --创建用户表空间 CREATE TABLESPACE namespace DATAFILE '/home/app/oracle/oradata/func27/namespace.dbf' SIZE 500M AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1M; --创建用户 --appuser CREATE USER appuser IDENTIFIED BY appuser DEFAULT TABLESPACE namespace PROFILE DEFAULT ACCOUNT UNLOCK; GRANT CONNECT TO appuser; GRANT RESOURCE TO appuser; GRANT CREATE SYNONYM TO appuser; ALTER USER appuser DEFAULT ROLE ALL; GRANT UNLIMITED TABLESPACE TO appuser; ALTER USER appuser QUOTA UNLIMITED ON app; --创建用户 --app CREATE USER app IDENTIFIED BY app DEFAULT TABLESPACE app PROFILE DEFAULT ACCOUNT UNLOCK; GRANT CONNECT TO app; GRANT RESOURCE TO app; GRANT CREATE ANY SYNONYM TO app; GRANT CREATE PROCEDURE TO app; GRANT CREATE VIEW TO app; GRANT CREATE SESSION TO app; GRANT CREATE SEQUENCE TO app; GRANT CREATE TABLE TO app; ALTER USER app DEFAULT ROLE ALL; GRANT UNLIMITED TABLESPACE TO app; ALTER USER app QUOTA UNLIMITED ON app;
总结
以上是编程之家为你收集整理的Oracle创建用户和表空间全部内容,希望文章能够帮你解决Oracle创建用户和表空间所遇到的程序开发问题。
如果觉得编程之家网站内容还不错,欢迎将编程之家网站推荐给程序员好友。
本图文内容来源于网友网络收集整理提供,作为学习参考使用,版权属于原作者。