Create schemas for new prod
create tablespace DATA datafile '+ORA_DATA' size 100M autoextend on;
create user OWNER identified by **** default tablespace DATA temporary tablespace TEMP;
create user USER identified by **** default tablespace DATA temporary tablespace TEMP;
grant connect, resource to OWNER;
grant create view,create synonym to OWNER;
alter user OWNER quota unlimited on DATA;
grant connect to USER;
grant create synonym,create view to USER;
grant execute on DBMS_CRYPTO to OWNER;
grant execute on DBMS_CRYPTO to USER;
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/10973950/viewspace-1851669/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- Create a New Parameter ID
- solaris vm create new lv
- create controlfile for new SID
- Object.create(..)和new(..)的內部實現Object
- oracle create a new database using backup controlfile to traceOracleDatabase
- no- valid devices were found on which to create new file systemsdev
- MM-step to create a new material type/valuation cloass//account category referenceGo
- ERROR 1135 (HY000): Can't create a new threadErrorthread
- 救命啊java.lang.OutOfMemoryError: unable to create new native threadJavaErrorthread
- java.lang.OutOfMemoryError- unable to create new native thread 問題排查JavaErrorthread
- java.lang.OutOfMemoryError: unable to create new native thread如何解決JavaErrorthread
- ORACLE 修改schemas的方法一Oracle
- CouchDB中的Schemas詳解
- Oracle 11g Default SchemasOracle
- MySQL案例-不同尋常的[ERROR]Can't create a new thread (errno 11)MySqlErrorthread
- ERROR 1135 (HY000): Can't create a new thread (errno 11)Errorthread
- Django REST framework API 指南(21):SchemasDjangoRESTFrameworkAPI
- SAP HANA Schemas 和 HDI ContainersAI
- Oracle下的Databse,Instance,SchemasOracle
- Sample Schemas建庫後手動建立
- 菜鳥調錯(一)——Maven專案部署到Jboss出現:Failed to create a new SAX parserMavenAI
- Oracle Database 19c安裝Sample SchemasOracleDatabase
- Oracle 12CR2 Install the Sample SchemasOracle
- MongoDB Guide Author Looking for Cool Schemas for BookMongoDBGUIIDE
- New start new hope!
- save the status of schema and gather all stat of schemas again.AI
- new self()與new static()
- new Child();new Child(1);
- spark大批量讀取Hbase時出現java.lang.OutOfMemoryError: unable to create new native threadSparkJavaErrorthread
- Information On Installed Database Components and Schemas (Doc ID 472937.1)ORMDatabase
- Information On Installed Database Components and Schemas (文件 ID 472937.1)ORMDatabase
- New
- Mongoose Schemas定義中timestamps選項的妙用Go
- 課程:A New History for a New China, 1700-2000: New Data and New Methods, Part 1
- Create DatabaseDatabase
- 從 ng build 支援的引數 --prod,談談 Angular workspace configurationUIAngular
- java.lang.OutOfMemoryError: unable to create new native thread問題排查以及當前系統最大程式數量JavaErrorthread
- create index/create index online區別Index