Home PC Games Linux Windows Database Network Programming Server Mobile  
  Home \ Database \ Oracle table Access Control     - php for Linux the MySQL extension module installation and configuration (Database)

- To install network scanning and packet sniffer tool Nmap 7.00 under ubuntu (Linux)

- FileZilla install on Ubuntu 14.10 (Linux)

- MySQL use the integer type (Database)

- iOS development -Launch Image and Launchscreen (Programming)

- CentOS How quickly customize kernel binary RPM package (Linux)

- CoreCLR compiled in Linux CentOS (Linux)

- Quota for Vsftpd do use disk quotas (Server)

- Oracle DATABASE LINK (DBLINK) Create (Database)

- Nginx DHCP TFTP Kickstart set up automatic installation system (Server)

- CentOS set up FTP server (Server)

- Configure the Linux kernel and use iptables to do port mapping (Linux)

- Linux Firewall IPCop Profile (Linux)

- Linux automatic installation and implementation (Linux)

- C language print various graphic (Programming)

- How to adjust the system time CentOS (Linux)

- CentOS 6.7 install Nagios Tutorials (Server)

- SQL statement to repair SQL Server database (Database)

- Ubuntu font settings: Using Windows Font (Linux)

- Android Studio installed in Ubuntu 15.04 (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;
- Linux upgrade Glibc (Linux)
- Node.js development environment deployment (Server)
- Linux tool curl and wget advanced use (Linux)
- How to Install lightweight Budgie desktop on Ubuntu 14.04 (v8) (Linux)
- Connect to the Oracle Database Help class (Database)
- Installation Enpass secure password manager on Ubuntu (Linux)
- Lazarus for Raspbian installation (Linux)
- Installation in lxml Python module (Linux)
- Install RAID 6 (Striping double distributed parity) (Linux)
- CentOS6 5 Configure SSH password Free (Linux)
- CentOS 6.4 dial-up Raiders (Linux)
- How to monitor Nginx (Database)
- Go constructed using an interpreted language (Programming)
- How to install Ubuntu California - the calendar application (Linux)
- Text editing and viewing text Linux command (Linux)
- Use the dd command to the hard disk I / O performance test (Linux)
- Django how to generate content in non-HTML formats (Programming)
- To obtain installation package (RPM) under RHEL6 (Linux)
- Linux, Eclipse flash back and reinstall the JDK methods (Linux)
- Red Hat Enterprise Linux Server 6.5 installation GCC 4.9.2 (Linux)
  CopyRight 2002-2022 newfreesoft.com, All Rights Reserved.