Home PC Games Linux Windows Database Network Programming Server Mobile  
           
  Home \ Database \ Oracle create user authorization and in PLSQL     - Experience RHEL7 new features (Linux)

- To install and deploy Java applications under CentOS 6.5 (Linux)

- How to turn Java String into Date (Programming)

- Download Google Android source code under Ubuntu 4.4 (Linux)

- For the FreeBSD install Adobe Flash plug-in (Linux)

- Java Collections Framework interfaces map (Programming)

- A step by step teach have to install multi-node cluster configuration Hadoop (Server)

- MySQL separation Amoeba achieve literacy (Database)

- fcntl file locking function add (Programming)

- The callback function used in C ++ (Programming)

- Linux System Getting Started Learning: The Linux log (Linux)

- Linux vi command list (Linux)

- Ubuntu 14.04 forget solution root password (Linux)

- How to use jgit to manage Git submodule (Linux)

- Oracle: RETURNING clause (Database)

- Vim (Linux)

- Wi-Fi hackers use to attack your seven methods (Linux)

- Shell Programming points to note about the function (Programming)

- CentOS7 complete step to install Hadoop2.7 (Server)

- ORA-01839 error caused by incorrect system date setting (Database)

 
         
  Oracle create user authorization and in PLSQL
     
  Add Date : 2018-11-21      
         
         
         
  1. Open the SQLPlus, according prompted for a user name and password to log in.
Note: If the users of the system, it can only use sysdba login. For example: sys as sysdba, enter the User's password.
2, after a successful login, you first create the table space, table space where I "StationSpace".
Create TableSpace StationSpace DataFile 'E: Oracle oradata StationSpace StationSpace.dbf' Size 1024M Uniform Size 128k;
3, after the table space is created, and then create the user.
Create User UserName Identified by Password Default TableSpace StationSpace;
4, after the user has been created, it can then give the user authorization.
Grant Connect, Resource, DBA to UserName;
     
         
         
         
  More:      
 
- Python Basics Tutorial - lambda keyword (Programming)
- Ceph cluster disk is no workaround for the remaining space (Server)
- PostgreSQL using the system cache to improve operational efficiency (Database)
- MySQL uses Federate engine mapping table to achieve operation of the local remote operation table (Database)
- Linux tmux tcpdump summary (Linux)
- Smack 4.1.x Upgrade Guide (Linux)
- Ubuntu 14.04 install AMD graphics driver is fully dual monitor solution (Linux)
- Linux Shell Scripting (Programming)
- Stucts2 values on the page and how the attribute values corresponding to the Action (Programming)
- Android project and coding specifications (Programming)
- Java Concurrency: synchronized (Programming)
- Hardware Firewall Basics (Linux)
- Seven kinds of NIC binding mode Detail (Linux)
- How to use Android Studio to play more package names APK (Programming)
- Linux Programming memory mapping (Programming)
- Oracle and MySQL difference between the jdbc (Database)
- Ubuntu 14.04 CodeBlocks configuration manually compile Boost 1.57.0 (Linux)
- Lazarus IDE Start Basics Tutorial (Linux)
- VirtualBox 4.3 Can not open a new task for a virtual computer solution (Linux)
- CentOS 6.5 set under Oracle 12c at startup (Database)
     
           
     
  CopyRight 2002-2020 newfreesoft.com, All Rights Reserved.