Home PC Games Linux Windows Database Network Programming Server Mobile  
           
  Home \ Database \ Oracle table Access Control     - Oracle 11g em start newspaper site's security certificate has a solution to the problem (Database)

- Linux configuration startup mount: fstab file (Linux)

- Nginx installation configuration Zabbix (Server)

- IntelliJ IDEA common list of shortcuts (Linux)

- Java memory-mapped file MappedByteBuffer (Programming)

- Linux file and directory permissions settings (Linux)

- Fedora 20, Fedora 19, CentOS 6 and RHEL6 users how to install Wine 1.7.15 (Linux)

- To setup Cocos2dx project under Ubuntu (Linux)

- Linux System Getting Started Learning: The Linux ac command (Linux)

- How to Install Apache on Linux servers (Server)

- How do you prevent other users from accessing your home directory in Linux (Linux)

- Kernel compile under Debian (Linux)

- Linux, modify the fstab file system can not start causing solve one case (Linux)

- Oracle DataGuard principles and basic configuration (Database)

- How to ensure the Linux SSH login security with one-time password (Linux)

- Integrated security administrator Linux accident management (Linux)

- Ubuntu program using the Sound Recorder (Linux)

- ImageMagick Tutorial: How to cut images in Linux command line (Linux)

- Docker - for the development and deployment of unified lightweight Linux containers (Linux)

- Getting Started with Linux system to learn: how to check in a package is installed on Ubuntu (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 yum command Detailed (Linux)
- Use HttpClient remote interface testing (Programming)
- Graphical development environment to build Android under Ubuntu 11.04 (Linux)
- DRBD-based installation and configuration of CentOS 6.5 (Server)
- Linux system on how to use rsync to synchronize data (Server)
- MySQL / MariaDB database master-slave replication (Database)
- Port is not being used, how will bind failure? (Server)
- Mumble installation source VoIP application on Ubuntu (Linux)
- Linux Crontab Timing task command Detailed (Linux)
- Performance comparison Fibonacci recursive and non-recursive (Programming)
- Under CentOS Linux automatic backup MySQL database daily (Database)
- Perl loop (Programming)
- Linux5.8 installed phpMyAdmin was unable to issue related php-mcrypt (Database)
- How do I switch from NetworkManager to systemd-network on Linux (Linux)
- Ten minutes to find out the character set and character encoding (Linux)
- Raspberry Pi configuration wireless hotspot (Linux)
- Linux Security (Linux)
- Oracle DataGuard principles and basic configuration (Database)
- CentOS yum configuration under local sources (Linux)
- impdp error ORA-31631, ORA-39122 (Database)
     
           
     
  CopyRight 2002-2020 newfreesoft.com, All Rights Reserved.