Shulou(Shulou.com)06/01 Report--

Login without password: sqlplus / as sysdba

View all current databases: select name from v$database

View the current database connection user: show user

View all tables of the current user: select table_name from all_tables

View table structure: desc table name

Create a new database user: create user username indentified by 'password'

Authorization: grant permissions / role to username

Change the database user password: alter user username identified by 'new password'

Check all the users in the database: select * from dba_users

View all users that can be managed: select * from all_users

View current user information: select * from user_users

Export table structure and data: exp username / password @ network connector file=d:\ daochu.dmp full=y

Import table structure and data: imp username / password @ network connector file=d:\ daochu.dmp

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.