数据库管理系统检查命令清单

1、.数据库管理系统测评检查命令Oracle数据库命令说明Oracle数据库管理系统测评检查命令数据库检查时主要使用select只读查看命令，主要查看用户情况、安全策略配置文件、日志等。cat /$ORACLE_HOME/rdbms/admin/utlpwdmg.sqlcat /$ORACLE_HOME/network/admin/sqlnet.oraselect * from v$version;select username,account_status from dba_users;select resource_name,limit from dba_profiles where prof

2、ile=DEFAULT;select granted_role from dba_role_privs where grantee=PUBLIC;show parameter O7_DICTIONARY_ACCESSIBILITY;show parameter auditshow parameter audit_sys_operations;show parameter audit_trail;select * from dba_stmt_audit_opts;select grantee from dba_tab_privs where table_name=AUD$ and grantee

3、 not in (DELETE_CATALOG_ROLE) and grantee not in (select grantee from dba_role_privs where granted_role=DBA);select resource_name,limit from dba_profiles where profile=DEFAULT and resource_type=KERNEL;select username,profile from dba_users;select * from dba_role_privs where granted_role= DBA;select

4、* from V_$PWFILE_USERS;archive log list;show parameter log_archive_dest;select * from role_sys_privs;select * from dba_sys_privsselect policy_name,status from dba_sa_policies;select * from sys.aud$ where ROWNUM5;SELECT name,password FROM user$ WHERE name=SYS;select name from v$database;select instan

5、ce_name from v$instance;MysqlMysql数据管理系统测评检查命令数据库检查时主要使用select只读查看命令，主要查看用户情况、安全策略配置文件、日志等（连接数据库：mysql uusername ppassword show databases；use mysql；）cat my.iniselect user();select host,user,password from mysql.user;show global variables like %timeout%;show variables like %skip_networking%;show variables like log_%;show variables;select * from mysql.user;select version();netstat -lnpt | grep 3306cat .mysql_historycat /etc/fSELECT DISTINCT CONCAT(User: ,u