728x90
SELECT * FROM DBA_USERS
WHERE USERNAME = '';
CREATE USER 'USER_NAME' IDENTIFIED BY ""
DEFAULT TABLESPACE 'DEFAULT_TABLESPACE_NAME'
TEMPORARY TABLESPACE 'TEMP_TABLESPACE_NAME'
PROFILE 'DEFAULT PROFILE';
SELECT * FROM DBA_ROLE_PRIVS
WHERE GRANTEE = '';
GRANT CONNECT, RESOURCE TO 'USER_NAME';
SELECT * FROM DBA_TAB_PRIVS
WHERE GRANTEE = '';
728x90
'ORACLE' 카테고리의 다른 글
DEPENDENCY (0) | 2022.10.28 |
---|---|
JOB 조회/등록/비활성화/변경/삭제 (0) | 2022.10.28 |
DIRECT PATH / APPEND / NOLOGGING (1) | 2022.10.19 |
DUAL (0) | 2022.10.19 |
ROWNUM (0) | 2022.10.19 |