Home PC Games Linux Windows Database Network Programming Server Mobile  
           
  Home \ Database \ Oracle table Access Control     - CentOS 5.3 under broadcom NIC dual activation issues (Linux)

- RHEL 7.1 compile and install Ganglia 3.7.1 (Server)

- Debian 8.2.0 (Jessie) fast clean installation tutorial (Linux)

- NAT and firewall under Linux (Linux)

- Archive log file size and redo log file size relationship (Database)

- MyCAT separate read and write to achieve MySQL Practice (Database)

- Implement binary search algorithm in C language (Programming)

- Top 10: HTML5, JavaScript 3D game engine and framework (Linux)

- Actual SSH port forwarding (Linux)

- Android child thread really do not update UI (Programming)

- When Linux virtual machine to another copy of the operating system, a static IP NAT mode Invalid (Linux)

- What Java 8 fastest garbage collector (Programming)

- How to add any of a Linux distribution beautiful fonts (Linux)

- Analysis of MySQL High Availability (Database)

- Oracle database, some basic grammatical structures (Database)

- Linux performance optimization features Tuned and ktune (Linux)

- In the case of using cgroups Ubuntu 14.04 and Docker (Linux)

- Linux SVN installation and configuration graphic tutorials (Server)

- Lambda expressions of evolution (Programming)

- Linux regex awk Comments (Linux)

 
         
  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, security encryption to transfer files between machines (Linux)
- Mumble installation source VoIP application on Ubuntu (Linux)
- How to track performance issues when using the Unity Game Development Android (Programming)
- Android Studio simple setup (Linux)
- Hackers is how the invasion and control of Things devices? (Linux)
- Why do you need close contact Rust 1.0 (Programming)
- Oracle Duplicate build DataGuard (Database)
- Revive Adserver ad server installation on Ubuntu 15.04 / CentOS7 (Server)
- In the case of using cgroups Ubuntu 14.04 and Docker (Linux)
- Struts2 study notes -Valuestack (value stack) and OGNL expression (Programming)
- The Linux kernel and AVL tree in red-black tree (Programming)
- How to configure AWStats in Ubuntu Server (Server)
- Linux operating system security settings initial understanding (Linux)
- After installation of Debian 6.0 do a few things first (Linux)
- Installation and Configuration rsync server under CentOS 6.3 (Server)
- Ubuntu 14.10 PPA installed Android Studio (Linux)
- PXE install CentOS 6.4 (Linux)
- CentOS 6.5_x64 install Oracle 11g R2 (Database)
- How to Install Apache on Linux servers (Server)
- Grading defense against Linux server attacks (Linux)
     
           
     
  CopyRight 2002-2022 newfreesoft.com, All Rights Reserved.