Oracle创建用户和表空间
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; (编辑:李大同) 【声明】本站内容均来自网络,其相关言论仅代表作者个人观点,不代表本站立场。若无意侵犯到您的权利,请及时与联系站长删除相关内容! |