Home PC Games Linux Windows Database Network Programming Server Mobile  
           
  Home \ Database \ Oracle create user authorization and in PLSQL     - Git delete files (Linux)

- Ubuntu install Geary (Linux)

- Linux regex awk Comments (Linux)

- Tmux create the perfect terminal management tool under CentOS (Linux)

- Java keyword final, static (Programming)

- Hadoop1.2.1 plug compilation (Server)

- Introduces Linux kernel compilation system and compiler installation (Linux)

- How to Install Android Studio on Ubuntu 15.04 / CentOS7 (Linux)

- A new method for Linux hidden files (Linux)

- CentOS 6.6 running level (Linux)

- systemd Power Management (Linux)

- Ubuntu 14.10 / 14.04 / 12.04 virtual users to install the printing software Boomaga (Linux)

- Linux systems dmesg command processing failures and system information collected seven usage (Linux)

- Installation and use GAMIT / GLOBK Software (Linux)

- Linux text processing tool of sed (Linux)

- To install Jetty server configuration in detail (Server)

- MongoDB data replication and data slices (Database)

- Linux system versions organize local root password cracking method (Linux)

- fcntl file locking function add (Programming)

- Secondary exponential smoothing prediction method implemented in Python (Programming)

 
         
  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:      
 
- Linux operating system Samba server configuration and use (Server)
- Ubuntu and Archlinux install Notepadqq 0.50.2 (Linux)
- RHEL7 unattended automatic installation DHCP + TFTP + SYSLINUX + TFTP + Kickstart (Linux)
- installation of Vim plugin YouCompleteMe under Ubuntu 15.04 (Linux)
- Linux and hardware (Linux)
- Getting jQuery - progress bar (Programming)
- Availability Hadoop platform - Oozie Workflow (Server)
- OpenNMS separate database (Server)
- iTerm - let your command line can also be colorful (Linux)
- RMAN backup file is much larger than the size of the database Cause Analysis (Database)
- Applications Linux leap second problem caused (Linux)
- C language binary tree (Programming)
- Ubuntu system process is bound CPU core (Linux)
- Detailed Linux platform chip programming process (Programming)
- Python in yield (Programming)
- How to manage Vim plugin (Linux)
- Ubuntu Server 14.04 installation Web server (Linux + Apache + MySQL + PHP) (Server)
- Android memory optimization of the memory cache (Linux)
- Laravel 4 Expansion Pack (Server)
- Use Oracle Data Guard to complete cross-platform database migration cases (Database)
     
           
     
  CopyRight 2002-2020 newfreesoft.com, All Rights Reserved.