Kbase P49613: How to grant ENOUGH QUOTA on DEFAULT TABLE SPACE to ORACLE u
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
28/10/2003 |
|
Status: Unverified
GOAL:
How to grant ENOUGH QUOTA on DEFAULT TABLE SPACE to ORACLE user?
GOAL:
How to grant permissions to an ORACLE user via command line/SQLPLUS?
FIX:
ALTER USER "<USER>" QUOTA UNLIMITED ON <TABLESPACE>;
i.e.,
ALTER USER "SCOTT" QUOTA UNLIMITED ON SYSTEM;
ALTER USER "SCOTT" QUOTA UNLIMITED ON USERS;
ALTER USER "SCOTT" QUOTA UNLIMITED ON TEMP;
Please note to use the default tablespace that user was created within. Also, any other tablespace that you will be using.