-- スキーマ指定テーブルの確認
SELECT * FROM DBA_SYNONYMS WHERE OWNER = 'AAA_SERVICE';
-- スキーマ指定テーブルの確認(テーブル名の指定)
--SELECT * FROM DBA_SYNONYMS WHERE OWNER = 'AAA_SERVICE' AND TABLE_NAME LIKE '%AVAI%';
OWNER |
SYNONYM_NAME |
TABLE_OWNER |
TABLE_NAME |
DB_LINK |
AAA_SERVICE |
PAY_HISTORY |
USER1 |
PAY_HISTORY |
|
AAA_SERVICE |
PAY_LOG |
USER1 |
PAY_LOG |
|
AAA_SERVICE |
BB_PAY_HISTORY |
USER1 |
BB_PAY_HISTORY |
|
テーブル付与権限を確認する
SELECT * FROM USER_TAB_PRIVS WHERE GRANTEE = 'AAA_SERVICE' ORDER BY TABLE_NAME;
GRANTEE |
OWNER |
TABLE_NAME |
GRANTOR |
PRIVILEGE |
GRANTABLE |
HIERARCHY |
AAA_SERVICE |
DB_NAME |
PAY_HISTORY |
USER1 |
UPDATE |
NO |
NO |
AAA_SERVICE |
DB_NAME |
PAY_HISTORY |
USER1 |
INSERT |
NO |
NO |
AAA_SERVICE |
DB_NAME |
PAY_HISTORY |
USER1 |
SELECT |
NO |
NO |
AAA_SERVICE |
DB_NAME |
PAY_HISTORY_SEQ |
USER1 |
SELECT |
NO |
NO |
AAA_SERVICE |
DB_NAME |
PAY_LOG |
USER1 |
INSERT |
NO |
NO |
AAA_SERVICE |
DB_NAME |
PAY_LOG_SEQ |
USER1 |
SELECT |
NO |
NO |