Home PC Games Linux Windows Database Network Programming Server Mobile  
           
  Home \ Database \ Oracle table Access Control     - Linux System Tutorial: Fix ImportError: No module named wxversion error (Linux)

- Linux basis: a comprehensive study pwd command (Linux)

- Install Debian Linux with R on the Android system (Linux)

- How to install Git client in Ubuntu (Linux)

- Linux Network Programming - raw socket instance: MAC Address Scanner (Programming)

- Linux Apache server security (Linux)

- Processor in protected mode of protection (Linux)

- How to run in support UDp Docker container JBoss data virtualization GA (Server)

- To install the latest version of the EPEL on CentOS 5.x or 6.x (Linux)

- CentOS 7 Add yum source (Linux)

- Oracle multi-table query optimization (Database)

- 10 example of the detection memory usage free Linux commands (Linux)

- vector C ++ sequence containers (Programming)

- Linux disk and File System Concepts (Linux)

- MySQL5.7 implement virtual column expression index (Database)

- JavaScript is implemented without new keywords constructor (Programming)

- HashMap in Android and Java different implementations (Programming)

- Linux command -nohup & (Linux)

- Linux ls command (Linux)

- 64-bit Windows Server 2012 R2 install Oracle 10g Second Edition (Database)

 
         
  Oracle table Access Control
     
  Add Date : 2018-11-21      
         
         
         
  Currently Oracle database has a system user SYSUSER have permission to all tables, another system wants to access a table in my database, I do not want him to control all the tables in my database, all I created a new user, the user can only control visit my database a table, with no other permissions.

Specific process is as follows:

1. The system SYS user login
conn sys / password as sysdba

2. Create a user
create user username identified by password
default tablespace user_data
temporary tablespace user_temp;
grant connect, resource to username;

3. The construction of the table tableA, authorization
GRANT ALL ON user A.tableA TO user B;

4. Built synonyms
CREATE SYNONYM user B.tableA FOR user A.tableA;
     
         
         
         
  More:      
 
- Wireless LAN security solutions (Linux)
- CentOS card fails to start at boot progress bar certmonger solve (Linux)
- Linux Getting Started Tutorial: / var / spool / clientmqueue fill the root directory (Linux)
- Linux environment variable configuration (Linux)
- RHEL6.5 replace local YUM source (Linux)
- Linux System Getting Started Learning: The Linux logrotate (Linux)
- Android engineers interview questions (Programming)
- Nodejs command-line program development tutorial (Programming)
- No password on Oracle and MySQL login (Database)
- Depth understanding of C language (Programming)
- Proper use Core Data multithreaded 3 ways (Programming)
- Bootable ISO image using GRUB (Linux)
- Linux environment to build next Cocos2dx-3.3.1 (Linux)
- Setting Wetty do not need an account login command line operations (Linux)
- Oracle GoldenGate tutorial Second, configure and use (Database)
- OpenCV 3.0 + Python 2.7 installation and testing under Ubuntu 14.04 (Linux)
- Difference Redhat5 and 6 YUM source configuration (Linux)
- Zabbix monitors Nginx status (Server)
- Oracle study notes view (Database)
- Mac OS X 10.10 Yosemite compiling OpenJDK 9 (Linux)
     
           
     
  CopyRight 2002-2022 newfreesoft.com, All Rights Reserved.