登录 sqlplus conn sys/sys as sysdba 忘记密码
直接登录:sqlplus conn scott/scott
解锁: alter user scott account unlock
枷锁: alter user scott account lock;
修改密码: alter user scott identified by 新密码
查询当前用户的所有表: select table_name from user_tables;
查询表结构:desc 表名
创建用户:create user lhp identified by 密码
给用户授权: grant dba to lhp
grant connect,resource to lhp
给用户授:查看其他用户表的权限 grant select any table to 用户名
创建表: create table 表名 as select * from scott.emp;
直接登录:sqlplus conn scott/scott
解锁: alter user scott account unlock
枷锁: alter user scott account lock;
修改密码: alter user scott identified by 新密码
查询当前用户的所有表: select table_name from user_tables;
查询表结构:desc 表名
创建用户:create user lhp identified by 密码
给用户授权: grant dba to lhp
grant connect,resource to lhp
给用户授:查看其他用户表的权限 grant select any table to 用户名
创建表: create table 表名 as select * from scott.emp;