database:oracle:user-rights
no way to compare when less than two revisions
Differences
This shows you the differences between two versions of the page.
Last revision | |||
— | database:oracle:user-rights [2018/03/04 22:30] – created odefta | ||
---|---|---|---|
Line 1: | Line 1: | ||
+ | ====== Create user with minimal rights ====== | ||
+ | |||
+ | < | ||
+ | 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 | ||
+ | / | ||
+ | </ | ||
database/oracle/user-rights.txt · Last modified: 2023/07/04 19:36 by 127.0.0.1