Oracle intrusion common operation command collation
- 2020-06-07 05:28:47
- OfStack
su?? oracle is not required and is suitable for use without an DBA password. You can access the sqlplus interface without a password.
2, sqlplus /nolog or sqlplus system/manager or.
3, SQL > connect/as sysdba; (as sysoper) or
connect internal/oracle AS SYSDBA ;(scott/tiger)
conn sys/change_on_install as sysdba;
4, SQL > startup; Start the database instance
5. View all current databases: select * from v$database;
select name from v$database;
6, desc v $databases; View the database structure field
7. How to check which users have SYSDBA and SYSOPER permissions:
SQL > select * from V_$PWFILE_USERS;
Show user; View the current database connection user
8. Enter test database: database test;
9. View all database instances: select * from v$instance;
Such as: ora9i
10. View all data tables of the current library:
SQL > select TABLE_NAME from all_tables;
select * from all_tables;
SQL > select table_name from all_tables where table_name like '%u%';
TABLE_NAME
------------------------------
_default_auditing_options_
11. View table structure: desc all_tables;
12. Display all field structures of ES109en. T_BBS_XUSER:
desc CQI.T_BBS_XUSER;
13. Obtain the records in CQI_ES120en_ES121en table:
select * from CQI.T_BBS_XUSER;
14. Add database users :(test11/test)
create user test11 identified by test default tablespace users Temporary TABLESPACE Temp;
15. User Authorization:
grant connect,resource,dba to test11;
grant sysdba to test11;
commit;
16. Change the password of database user :(change the password of sys and system to test.)
alter user sys indentified by test;
alter user system indentified by test;
2, sqlplus /nolog or sqlplus system/manager or.
3, SQL > connect/as sysdba; (as sysoper) or
connect internal/oracle AS SYSDBA ;(scott/tiger)
conn sys/change_on_install as sysdba;
4, SQL > startup; Start the database instance
5. View all current databases: select * from v$database;
select name from v$database;
6, desc v $databases; View the database structure field
7. How to check which users have SYSDBA and SYSOPER permissions:
SQL > select * from V_$PWFILE_USERS;
Show user; View the current database connection user
8. Enter test database: database test;
9. View all database instances: select * from v$instance;
Such as: ora9i
10. View all data tables of the current library:
SQL > select TABLE_NAME from all_tables;
select * from all_tables;
SQL > select table_name from all_tables where table_name like '%u%';
TABLE_NAME
------------------------------
_default_auditing_options_
11. View table structure: desc all_tables;
12. Display all field structures of ES109en. T_BBS_XUSER:
desc CQI.T_BBS_XUSER;
13. Obtain the records in CQI_ES120en_ES121en table:
select * from CQI.T_BBS_XUSER;
14. Add database users :(test11/test)
create user test11 identified by test default tablespace users Temporary TABLESPACE Temp;
15. User Authorization:
grant connect,resource,dba to test11;
grant sysdba to test11;
commit;
16. Change the password of database user :(change the password of sys and system to test.)
alter user sys indentified by test;
alter user system indentified by test;