07/17: Oracle > checking privileges
Category: Oracle
Posted by: hajime osako
iT-folder IT関連情報を配信
Oracle/PLSQL: Oracle System Tables
DBA_USERSの参照:
select USERNAME,ACCOUNT_STATUS from DBA_USERS;
SYSDBA/SYSOPER権限ユーザの確認:
select * from v$pwfile_users;
Check privileges by table name:
select * from dba_tab_privs where table_name = 'xxxxxx';
Checking the owner of table:
select owner, table_name from dba_tables where table_name = 'xxxxxxxx';
Search the column
select owner, table_name, column_name from dba_col_comments where column_name like '%xxxxx%'; (CAPITAL)
Checking the value of timed_statistics:
select value from v$parameter where name = ‘timed_statistics’;
Check SQL values:
SELECT
a.sql_text,
b.name,
b.position,
b.datatype_string,
b.value_string
FROM
v$sql_bind_capture b,
v$sqlarea a
WHERE
b.sql_id = a.sql_id
Oracle/PLSQL: Oracle System Tables
DBA_USERSの参照:
select USERNAME,ACCOUNT_STATUS from DBA_USERS;
SYSDBA/SYSOPER権限ユーザの確認:
select * from v$pwfile_users;
Check privileges by table name:
select * from dba_tab_privs where table_name = 'xxxxxx';
Checking the owner of table:
select owner, table_name from dba_tables where table_name = 'xxxxxxxx';
Search the column
select owner, table_name, column_name from dba_col_comments where column_name like '%xxxxx%'; (CAPITAL)
Checking the value of timed_statistics:
select value from v$parameter where name = ‘timed_statistics’;
Check SQL values:
SELECT
a.sql_text,
b.name,
b.position,
b.datatype_string,
b.value_string
FROM
v$sql_bind_capture b,
v$sqlarea a
WHERE
b.sql_id = a.sql_id