Home PC Games Linux Windows Database Network Programming Server Mobile  
           
  Home \ Database \ Oracle table Access Control     - installation process of Matlab 2012a under Ubuntu 14.04 (Linux)

- Snapshot DataGuard (Database)

- JBPM6 Installation and Configuration Tutorial (Linux)

- Zombie process under Linux (Linux)

- Perl said method B if A judge (Programming)

- How to prevent page five invisible killer (Linux)

- Installation GitLab appears ruby_block supervise_redis_sleep action run (Linux)

- CentOS 6.x and CentOS7 install MPlayer (Linux)

- Automatic and Manual Proxy Settings Switch GNOME Shell Extension Proxy Switcher Recommend (Linux)

- Linux dd command make U disk boot disk (Linux)

- Growth since Oracle set the table space (Database)

- CentOS and RHEL installation under GAMIT10.6 (Linux)

- Gitblit adopted Ticket collaborative development model (Linux)

- Common Linux System Troubleshooting (Linux)

- Linux resource restriction level summary (Linux)

- Linux system security audit tools scan nessus installation tutorial (Linux)

- Crawl use Wireshark packet on remote Linux (Linux)

- How to adjust the system time CentOS (Linux)

- Ubuntu 14.10 How to install office suite Calligra Suite 2.8.7 (Linux)

- Linux kernel programming parameter passing between modules and function calls (Programming)

 
         
  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:      
 
- Linux distributed message queue RocketMQ deployment and monitoring - Dual Master (Server)
- MySQL Tutorial: Using tpcc-mysql pressure measurement (Database)
- Linux landing problem (Linux)
- Linux system started to learn: how to solve the xxx is not in the sudoers file error (Linux)
- VMware ghost Linux card error (Linux)
- Linux process or thread is bound to a CPU (Programming)
- To assign multiple IP addresses NIC on the CentOS 7 (Linux)
- Android View event delivery (Programming)
- How to install Perl modules from CPAN (Linux)
- Oracle Client Easy Connection error ORA-12154, TNS-03505 (Database)
- Formatting Java floating-point types (Programming)
- Use Markdown editor for document work under Linux (Linux)
- Nginx server security configuration (Server)
- Ubuntu Tutorial - Manually install Oracle Java JDK 8 (Linux)
- Mahout source code analysis: FP-Growth algorithm parallelization (Programming)
- Process monitoring tools Supervisor start MongoDB (Database)
- About Auto Layout and frame (Programming)
- Ubuntu and Archlinux install Notepadqq 0.50.2 (Linux)
- Linux virtual machine how to access the Internet in a virtual machine when using NAT mode (Linux)
- IOS distributed management using GitHub project development (Linux)
     
           
     
  CopyRight 2002-2022 newfreesoft.com, All Rights Reserved.