实践Oracle用户管理

Posted on | In | Visitors

user for DDL

1
2
3
4
5
6
7
8
9
10
11
12
13
-- Create the user
create user UMDB_DEV identified by "UMDB_DEV_2014"
  default tablespace DATSPACE
  temporary tablespace TEMP;
-- Grant/Revoke role privileges
grant connect to UMDB_DEV;
grant resource to UMDB_DEV;
-- Grant/Revoke system privileges
grant create any sequence to UMDB_DEV;
grant create any table to UMDB_DEV;
grant create any view to UMDB_DEV;
-- Grant/Revoke tablespace privileges
grant unlimited tablespace to UMDB_DEV;

user for DML

1
2
3
4
5
6
7
8
9
10
-- Create the user
create user umdb_dev_dml identified by "umdb_dev_dml_2014"
  default tablespace DATSPACE
  temporary tablespace TEMP;
-- Grant/Revoke role privileges
grant connect to umdb_dev_dml;
-- Grant/Revoke system privileges
grant create any synonym to umdb_dev_dml;
-- Grant/Revoke tablespace privileges
grant unlimited tablespace to umdb_dev_dml;