User Tools

Site Tools


database:oracle:user-rights

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

database:oracle:user-rights [2018/03/04 22:30] (current)
odefta created
Line 1: Line 1:
 +====== Create user with minimal rights ======
 +
 +<​code>​
 +CREATE USER SNTSP6 IDENTIFIED BY sntsp6
 +DEFAULT TABLESPACE DATA
 +TEMPORARY TABLESPACE TEMP
 +PROFILE DEFAULT
 +/
 +GRANT RESOURCE TO SNTSP6
 +/
 +GRANT CONNECT TO SNTSP6
 +/
 +GRANT UNLIMITED TABLESPACE TO SNTSP6
 +/
 +</​code>​
  
database/oracle/user-rights.txt ยท Last modified: 2018/03/04 22:30 by odefta